Conditional Formatting Help

[Brian]

Howdy All,


I want to format CELLS B1 thru H1 to highlight light gray if A1 equals YES,
or highlight green if A1 equals STARTED.
I also want to be able to copy this down thru successive rows (i.e., if A2
equals YES, then B2 thru H2 highlight light gray).

Thanks,
Brian

 

[Dave Peterson]

Select B1:Hxx.
And with the activecell on Row 1:

Format|conditional formatting:
formula is: =$A1="YES"
select a nice format (using the patterns tab)

Click add
formula is: =$a$1="Started"
select a nice format

 

[Brian]

Thanks Dave.

Exactly what I needed!

Select B1:Hxx.
And with the activecell on Row 1:

Format|conditional formatting:
formula is: =$A1="YES"
select a nice format (using the patterns tab)

Click add
formula is: =$a$1="Started"
select a nice format