Can I fill colour in a excel cell from a return from an "IF" test.

W

williamw

I have entered an "if" statement in excel to return true or false . Can I
additionally change the cell fill colour automatically based on the Returned
value eg True - blue or False - red
 
B

Bob Phillips

Using conditional formatting you can.

Look up 'Highlight cells that meet specific conditions' in the Answer
wizard in help

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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 3
How can i put text in a cell depending on colour 0
How can I test for colour format in if statements? 1
cell vlue based on cell back colour 7
Colour Fill 9
Fill cell colour based on input in another cell 2
Help with conditional formatting in Excel 2010 8
Need a ) somewhere in ISERROR formula but don't know where to put it 3

Top