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.