austenr
08-16-2007, 05:39 PM
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.
Oh and I cannot just remove the * it has to stay.