fill cell with colour if preceding cell is a negative value

[POP]

If cell c3 is a negative value how do I colour c4 automatically?

 

[Pimamedic]

The background color or the text color in Cell C4??

 

[Kassie]

You would use Conditional Formatting. So, click on the cell you want to
colour - C4, click on Format, conditional Formatting, change the option Cell
Value Is to Formula is, and insert the following formula: =C3<0. Click on
the format tab, click on Patterns, and select the colour you want

--
HTH

Kassie

Replace xxx with hotmail

 

[POP]

background colour

The background color or the text color in Cell C4??

 

[Pimamedic]

Select cell you want to format select format, conditional format, formula
then =a1<0 then select format pattern select color you want