MS Excel Conditional Formatting - Ignore "-"
Posted on 2012-03-12
I'm using conditional formatting in Excel 2010 to identify values in a table greater than a certain value. Unfortunately, the table has a dash ('-') in each cell where there is no value and for some reason this meets the criteria so the cell is shaded along with the cells that have the relevant value. Can anyone suggest a way around this?
If it involves using multi-criteria, can you tell me how to set up this as cant see how to do so in Excel 2010 (used to be able to do this in Excel 2003).