P
POP
If cell c3 is a negative value how do I colour c4 automatically?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Pimamedic
The background color or the text color in Cell C4??
K
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
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
P
POP
background colour
Pimamedic said:The background color or the text color in Cell C4??
P
Pimamedic
Select cell you want to format select format, conditional format, formula
then =a1<0 then select format pattern select color you want
then =a1<0 then select format pattern select color you want