Conditionally format row based on cell value in Excel 2011 Mac
- by kojiro
I'm using Excel Mac 2011. I have read some of the other answers, but this question is different because I want to apply conditional formatting to an entire row when its cell in column B contains the value 'Y'. Simple conditional formatting just formats that one cell.
Whenever the field at column B for any given row contains the value 'Y', I'd like…