color fill cells based on IF function or formula
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 |
color fill cells based on IF function or formula
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 |
All times are GMT +1. The time now is 03:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com