Conditional Formatting - Formula to fill cell using >%

[sbres]

Using Excel 2007, I have dollar values in columns A, B and C. C=B-A. I
would like to highlight the cells in column C red if the cell value is
greater than 5% of the value in column A.
Here is my formula, can someone please tell me what I'm doing wrong? The
formatting highlights every cell, regardless of it's value.

=$C$2>($A$2*0.05)

 

[Huber57]

Get rid of your absolute references (the $'s).

Then try it again.

HTH.

 

[Ashish Mathur]

Hi,

Try this =$C2>($A2*0.05)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com