Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
write a function to determine if cells have names | Excel Worksheet Functions | |||
Subtract a group of cells from a total based on ending date | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions | |||
Coloured cells based on formula | Excel Worksheet Functions | |||
Importing Data Into Formula Based Cells | Excel Worksheet Functions |