Home

Add two formulas to one cell?

Don_101
Occasional Visitor

Hi,

I have created a formula which changes the colour of a cell depending on certain inputs on the worksheet. However, I need the cell to change colour from red to green and include the phrase "complete". 

Is there a simple solution to the above issue?

The formula I use is: =IF(D5>0,IF(ISBLANK(I5),"Red","Green"),"white")

Capture.PNG

 

Thank you

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies