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
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.