Font Color

[Pete]

I have a dollar value in cell A2. I would like the font color to change to
RED when the value in cell A2 is equal to, or less than, 25% of the dollar
value in cell A3. Is there an easy way to do this in Conditional Formating?

Any help appreciated,
Pete

 

[Kassie]

Hi

Select cell A2, click on Format, Conditional Formatting.
Change Cell Value is to Formula Is, and enter the following formula
=A2<=A3*.25
Click on Format, select Font, change Font Color to red

--
HTH

Kassie

Replace xxx with hotmail

 

[Pete]

Kassie,

Thanks - that works perfectly

Pete

Hi

Select cell A2, click on Format, Conditional Formatting.
Change Cell Value is to Formula Is, and enter the following formula
=A2<=A3*.25
Click on Format, select Font, change Font Color to red

--
HTH

Kassie

Replace xxx with hotmail