If statement to change cell fillcolor

**redders** · 03-25-2010, 01:32 PM

Hi All

Is it possible to use an IF statement to change a cells fills color? I am wanting to change a cells fill color if my IF statement is true, and if false then make it nofill.

Thanks for any assistance

Redders

**martindwilson** · 03-25-2010, 01:39 PM

yes read the help file on conditional formatting
free tutorial here
http://www.free-training-tutorial.co...ormatting.html

**redders** · 03-25-2010, 01:54 PM

Hi martindwilson

Thanks for pointing me to those great newbie tutorials and I am aware of conditional formatting but it wont do what I want in this case, and thats probably because I explained myself badly.

What my if statement is doing on my worksheet is looking at the corresponding cell on another worksheet and filling the cell color on my current worksheet depending on what is on the other worksheet. eg. IF c2 on the other worksheet is 'B' then fillcolor otherwise nofill.

If there is a way for conditional formatting to do this without the IF statement then I would very much appreciate your help.

Thanks

Redders

**ChemistB** · 03-25-2010, 02:01 PM

Conditional Formatting does not allow you to directly reference a cell in another worksheet. However, if you name the cell, you can use the name of that cell. For example, in conditional formatting for A1 in Sheet1;
=ISTEXT(Sheet2!A2) is not allowed but if you name sheet2!A2 ="example"
=ISTEXT(example) works.
Are you familiar with naming cells?

**redders** · 03-25-2010, 02:06 PM

Hi ChemistB

Is it possible to name a range in the other worksheet and use that? The other worksheet has a range of cells from C-NB so its quite long and this new worksheet needs to look at every individual cell and filcolor depending on whats on that other worksheet? I have an idea on how to name cells, just having to name each one would be excessive.

Sorry for my ignorance, just way not an excel guru thats why you guys here are such a great resource.

Redders

**ChemistB** · 03-25-2010, 02:17 PM

Sounds doable. Can you upload a dummy workbook with an example of what you will have on sheet1 and sheet2? That way I can see more clearly what you are going for (e.g. can it match any cell in sheet2 or the corresponding cell location only.).

**redders** · 03-25-2010, 02:22 PM

Hi ChemistB

I think I shall mark this one as solved. I am happy to have my second worksheet return a value, as well as a fillcolor, if the condition is true from the first worksheet. By then using conditional formatting on whether the cell contains a value or not, I also can get the fillcolor happening so for me problem solved.

Thank you both for your assistance

Redders