Look in help for conditional formatting, in your case select E30:E45
abd use formula is and

=$B$20="x"


--

Regards,

Peo Sjoblom



"Victor Jones" <Victor wrote in message
...
I am trying to color fill certain cells based on the input of another cell
using the IF function

ie: =IF(B20 = "x",E30:e45 would color fill yellow,leave it alone

I hope this makes some sense

Thanks Vic