Excel cond. formatting

G

geordiebri

I'm looking to format a series of cells conditionally, ie
if cell H7 reads "YES" then I want cells H1->H6 to all go
green. Conditional formatting will allow me to do one
cell, I know, but how do I extend this?

I need this to happen automatically, not thru Macro's if
at all possible.

Cheers!

GB
 
B

Bob Phillips

Formula

=$H$7="YES"

for each of H1:H6 (can be done in one selection).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
G

Gord Dibben

GB

Select H1:H6

Format>CF>Formula is: =$H$7="YES"

Note the dollar signs to fix the reference cell.

Pick a nice green color and OK your way out.

Gord Dibben Excel MVP
 
Top