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