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.

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
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Changing color after enter number on top" <Changing color after enter
number on wrote in message
...
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.