Conditional Formatting Help

B

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
 
D

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
 
B

Brian

Thanks Dave.

Exactly what I needed!


Dave Peterson said:
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
Click to expand...
 
Top