Conditional Formating

Topic

New Reply

Excel 2000

I know this should be simple…but I’m stuck.

I would like the font color of A44 to change if the value in M44 is greater than 0, otherwise, I don’t want the font color to change.

Can someone please help me?

Reply | Quote

Replies

It’s simple but not obvious.

What you do is select A44, goto Format, Conditional Formatting and the in the consequent dialog change the dropdown Cell Value Is to Formula Is. Then enter =M44 > 0, in the space provided. Then click the format button and set the font color to the value you want when the condition is true.

That should do it for you.

Andrew C

Reply | Quote

Andrew,

Thanks for your help…it works perfectly….

Reply | Quote