Solved: Conditional Formatting problem

[austenr]

I need to apply conditional formatting to some cells. These cells are currently filled with *. I need to have the cells highlight yellow if a number greater than 4 populates the cell. If I use cell value > 4 all of the cells with the * are highlighted. Is it because * in ASCII is a dec > 4? :dunno

Oh and I cannot just remove the * it has to stay.

[asingh]

Hi,

Attached is a sheet..which will format as per your requirement.

Two conditions had to be used in conditional formatting..!

regards,

asingh

[rory]

You can use =AND(ISNUMBER(A1),A1>4) as a CF formula and it should work.

[austenr]

Thanks guys.