Forum Discussion
Solved
Conditional Formatting exception formula
Hi, I have a data set where I would like to highlight the cell if the cell value is "N". However in the same data set, I also have cell values of "N/A". None of the existing preset rule seems to...
To highlight any non-blank cell except one with question mark you may use
=(A2<>"")*(A2<>"?")Dates in Excel are actually numbers. Except texts which looks dates, but formatting won't convert them into the dates.
To highlight any non-blank cell except one with question mark you may use
=(A2<>"")*(A2<>"?")Dates in Excel are actually numbers. Except texts which looks dates, but formatting won't convert them into the dates.
Brilliant, thank you
chwar750 , you are welcome