Conditional Formatting

K

Kimberly5590

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
 
S

Suresh

Format>Conditional Formatting under this you can define a formula referring
to the cell H5="open" and define the conditional formats. You can specify
upto 3 different conditions and you can also specify them within a formula,
such as an if function
 
K

Kimberly5590

I understand how to format one cell, I'm just not sure how to format
multilple cells within one row based on whats in that one cell.

What I want to see is if h5="open" the color fill h1 through o1 with RED...
 
G

Gord Dibben

Kimberly

Yes, through Conditional Formatting.

Select H1:O1 and Format>Conditional Formatting>Condition 1>Formula is:

=$H$5="OPEN" Format to Red Pattern

Hit "Add" button to set Condition 2

Condition 2>Formula is:

=$H$5="Closed" Format to Green Pattern


Gord Dibben Excel MVP
 
Top