color fill cells based on IF function or formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Look in help for conditional formatting, in your case select E30:E45
abd use formula is and

=$B$20="x"
 
Back
Top