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
microsoft-excel
|conditional-formatting
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:
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