Highlighting Entire Row using CF

[Guest]

Can I use a conditional format to highlight a entire row, say A1:A20 when
cell value in A21 equals the text "Open" for one color and set another row
color when it the cell value is "Closed"? Much thanks.

 

[Guest]

Hi davisk,

Do I assume correctly that you mean highlight column, not row because A1:A20
is a column? If so then select the range A1:A20, open the conditional format
dialog box and set the conditional format formula as follows:-

=A$21="Open"

Set the required format for Open.

Click Add in the Conditional format dialog box and add a similar formula:-

=A$21="Closed"

Set the required format for Closed.

Note that the row must be absolute with the $ sign. I left the dollar sign
off the column because you could include other columns with the Open or
Closed in their respective row 21.

 

[David Biddulph]

Select A1:A20. Format/ Conditional Formatting/ Formula Is/ =A$21="Open"
Choose your highlight colour.
Similarly for "Closed".

 

[Guest]

No it was suppose to be row, I meant to say like A1:M1....
Your formula worked great; appreciate the quick response.
Thanks to all