stefanaalten
Board Regular
- Joined
- Feb 1, 2011
- Messages
- 71
- Office Version
- 365
- Platform
- Windows
How can I format a cell based on a value being something other than one of two values? Specifically, I have data in five columns ($P$32:$Q$709,$S$32:$AA$709) where each cell can be one of "y", "n" or something else, e.g. "s", "p", "f", "?", etc.
I would like to format cells with "y" in green text, cells with "n" in red text, and cells with something else with blue text.
To evaluate the condition for an individual cell, e.g. P32, is easy:
IF(OR(P32="y",P32="n"),FALSE,TRUE)
But how do I do this for my range of data - should I replace the cell reference with a placeholder/variable of some kind? I'm using Excel 2007.
I would like to format cells with "y" in green text, cells with "n" in red text, and cells with something else with blue text.
To evaluate the condition for an individual cell, e.g. P32, is easy:
IF(OR(P32="y",P32="n"),FALSE,TRUE)
But how do I do this for my range of data - should I replace the cell reference with a placeholder/variable of some kind? I'm using Excel 2007.