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