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.

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.

--
Regards,

OssieMac


"davisk" wrote:

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.

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

"davisk" wrote in message
...
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.

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:-)

"OssieMac" wrote:

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.

--
Regards,

OssieMac


"davisk" wrote:

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.