Select cell A2
From the menu bar, select Conditional Formatting
Change the top left box from "Cell value is" to "Formula is".
To the right of "Formula is" enter (without the quotes) "=A1<0"
Click on "Format..." button
Select Patterns tab
Choose Colour
OK
"Sorin Danila" <Sorin
wrote in message
...
How can I fill color in one cell related to another cell values. For
example:
If 10A10, A2 to be filled with yelow. If A1<0, A2 to be filled with red.
I
want to use this in a maintenance worksheet.