Colouring a range of cells if one cell equals "No"

**johnmitch38** · 06-05-2009, 07:55 AM

I want to make cells a1:a10 go grey if cell a5 equals "no".

im on excel 07.

I know this is probably in conditional formatting but i can't seem to figure it out.

Please help..

**NBVC** · 06-05-2009, 07:58 AM

Select A1:A10 and go to Home tab... Conditional Formatting and select New Rule and then select Use a formula to determine which cells to format

Enter formula: =$A$5="no"

Click Format to choose your colour scheme

**johnmitch38** · 06-05-2009, 08:17 AM

excellent thanks, can i copy and paste this for a whole table?

I want it to apply to each row in a table but if i drag the cells down it doent seem to work.

**johnmitch38** · 06-05-2009, 08:37 AM

I already have validation and formulas in the other cells in the table though.

Is there a way i can just copy the conditonal formatting only, nothing else?