Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 stackoverflow.com Mar 28 '13 at 13:50

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

2  
Google conditional formatting in excel and just use that exact same formula –  Dan Mar 28 '13 at 11:02
    

1 Answer 1

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:

=IF(OR(ISBLANK(E23),ISBLANK(E24),ISBLANK(E25)),1,0)

Set this to red. And

=IF(OR(ISBLANK(E23),ISBLANK(E24),ISBLANK(E25)),0,1)

Set this to green.

share|improve this answer

Your Answer

 
discard

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