Conditionally format row based on cell value in Excel 2011 Mac

Posted by kojiro on Super User See other posts from Super User or by kojiro
Published on 2012-04-11T17:28:30Z Indexed on 2012/04/11 17:32 UTC
Read the original article Hit count: 399

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 to format that row. Using Mac Excel's so-called "classic" conditional formatting, I have this:

Manage conditional formatting rules panel

I would really like to apply that to every row, but it just paints the entire sheet red (because $B$3 contains "Y"). I can't seem to figure out how to get the reference to whatever is in field B for this row in the rule.

© Super User or respective owner

Related posts about microsoft-excel

Related posts about conditional-formatting