Home

Excel Help

Jamessharpe
Occasional Visitor
Hi All,

I am having a nightmare trying to figure out something in excel.

Right so here it goes as I try to explain, I have data in cell I2 which states at the moment 8-8 and due to my conditional formatting the cell highlights red and if I change it to for example 6-1 it will highlight yellow which is all fine, but in cell J2 I need it to insert one of 4 options (Key Player, Keep Informed, Moniter and Keep satisfies) dependent on the colour of the cell in I2.
Could anyone please help?

Thanks in advance
1 Reply

You may use same formulas as in your conditional formatting rules to select text value for J2

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