CHANGE COLOR OF CELL

[Guest]

Hi all,
I like to change a range of cells in a column below after entering a number
on top. For instanse if I type 1 a range of let's say 50 cells below must
change from white into grey.

 

[Max]

Try:

Select the target range, say A2:A51

Click Format > Conditional Formatting

Under Condition 1, make the settings as:
Formula Is| =$A$1=1
Click Format button > Patterns tab > Grey? > OK
Click OK at the main dialog

Test it out by typing a "1" into A1, the CF will trigger
and A2:A51 will be filled grey.

Clear the cell A1 with the delete key, the grey fill disappears