Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm doing some excel formatting, with below formula being used:

=IF(OR(ISBLANK(E23),ISBLANK(E24),ISBLANK(E25)),"Section Incomplete","Section Complete")

Basically, When the cells E23, E24 and E25 are filled then a cell will prompt a message "Section Complete" otherwise, either of cells is blank then "Section Incomplete".

What I want to do is, When it is "Section Complete", the background fill of the cell should be Green and when Incomplete, has to be Red.

Please advise if you have any ideas.

share|improve this question

migrated from Mar 28 '13 at 13:50

This question came from our site for professional and enthusiast programmers.

Assuming the cell with the IF condition is E26, then you'll need to go to

  1. Conditional Formatting found in the Home tab
  2. New Rule
  3. Use a formula to determine which cells to format
  4. In the text box enter =if(E26="Section Complete, 1, 0)
  5. Click Format
  6. Click Fill and select the green color you want

Repeat this process for "Section Incomplete" with a new rule on the same cell.

The above is assuming you want to have the text "Section Complete/Incomplete" in the cell. In case you don't then just put your formula as the rule:


Set this to red. And


Set this to green.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.