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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Can I fill colour in a excel cell from a return from an "IF" test. (https://www.excelbanter.com/excel-worksheet-functions/19038-can-i-fill-colour-excel-cell-return-%22if%22-test.html)

williamw

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

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

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)

"williamw" wrote in message
...
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

All times are GMT +1. The time now is 06:15 PM.