Conditional Formatting
Kimberly
Yes, through Conditional Formatting.
Select H1:O1 and FormatConditional FormattingCondition 1Formula is:
=$H$5="OPEN" Format to Red Pattern
Hit "Add" button to set Condition 2
Condition 2Formula is:
=$H$5="Closed" Format to Green Pattern
Gord Dibben Excel MVP
On Thu, 17 Nov 2005 11:11:02 -0800, Kimberly5590
wrote:
Hi,
I am trying to write a condition if one cell meets the condition (Example H5
= OPEN) then turn cells H1 through O1 to red (Color fill)
If H5 = Closed then turn Cells H1 through O1 to Green
Is this something I can do in Excel?
Any help would be greatly appreciated.
Thanks
|