CHANGE COLOR OF CELL

  • Thread starter Changing color after enter number on top
  • Start date
C

Changing color after enter number on top

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.
 
M

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
 
Top