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

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

"POP" wrote:

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

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" wrote:

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

background colour


"Pimamedic" wrote:

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

"POP" wrote:

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

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

"POP" wrote:

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