select rangescondition 1 FORMULA is
=OR($D$7="yes",$E$7="yes")
format as desired
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Bren" wrote in message
...
i am trying to auto color cells,
For example: i want to change the color of cells A7,B7,C7 when i enter yes
or no into cell D7 or E7
so if i enter yes into D7 or E7 then A7,B7 and C7 would turn green and if
i
enter no into D7 or E7 cells A7,B7 and C7 would turn red.

I have looked through the conditional formatting,but most of it is to much
for me.

Thanks
Bren