Skip to Content
0
Former Member
Jun 25, 2009 at 10:46 AM

How to set input ready query cell is different color?

554 Views

Dear All

Hi, everyone, hereby i have a IP question.

i would like to know, how to set the input ready query's cell different color between those cell which is unable to change value one in workbook..?

Example :

For my workbook which have a input ready query,

i have 4 rows for my input ready query report.

For the first row which is not input ready cell and unable to change any value for the cell, then following rows's cell can be change value,

so, i would like to make first row's color cell different with following row's cell.

In additional, all value of cell is initial zero.

therefore, is there any mehtod to make different color between able cell and unable cell?

Thanks a million.

Regards,

WenLong.