color fill cells based on IF function or formula

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
 
P

Peo Sjoblom

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

=$B$20="x"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function for summing or counting cells based on a specified fill color 2
Excel VBA 1
add value of cells based on the formatted fill color 3
fill a cell based on another cells value 3
Color Matching of Cells? 1
Fill color with if function 4
Counting cells with conditional formatting 3
If function using cell format as the condition 2

Top