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.