color fill cells based on IF function or formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Victor Jones - 23 Nov 2005 15:06 GMT

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

Reply to this Message

Peo Sjoblom - 23 Nov 2005 15:17 GMT

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

=$B$20="x"

Signature

Regards,

Peo Sjoblom

> I am trying to color fill certain cells based on the input of another cell
> using the IF function
[quoted text clipped - 4 lines]
>
> Thanks Vic

Reply to this Message