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.
Hi NikolinoDE,
I have managed to vary your formula which you provided to the original poster for my own work book but have a couple of snagging issues. I am wanting to highlight any cell which is not empty except for cells with a question mark.
I have used the formula: =AND(ISTEXT(A2), A2<>"?") but I have some instances where some cells with dates in them haven't been highlighted but others have. I have checked these cells and they have the same format as other highlighted cells
I have managed to vary your formula which you provided to the original poster for my own work book but have a couple of snagging issues. I am wanting to highlight any cell which is not empty except for cells with a question mark.
I have used the formula: =AND(ISTEXT(A2), A2<>"?") but I have some instances where some cells with dates in them haven't been highlighted but others have. I have checked these cells and they have the same format as other highlighted cells
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
