SOLVED

Conditional Formatting Error - 1st time poster, please be gentle!

%3CLINGO-SUB%20id%3D%22lingo-sub-2692864%22%20slang%3D%22en-US%22%3EConditional%20Formatting%20Error%20-%201st%20time%20poster%2C%20please%20be%20gentle!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2692864%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I'm%20trying%20to%20conditionally%20format%20a%20cell%20so%20it%20shows%20a%20traffic%20light%20according%20to%20result%2C%20simple.%3C%2FP%3E%3CP%3E%25%2090%2B%20%3D%20green%3C%2FP%3E%3CP%3Ebetween%2060-90%20%3D%20Yellow%3C%2FP%3E%3CP%3ELess%20than%2060%20%3D%20Red%3C%2FP%3E%3CP%3EI've%20tried%20both%20with%20per%20cent%20and%20number%20options%20and%20neither%20are%20giving%20me%20the%20correct%20result%20which%20should%20be%20yellow%3F%20What%20am%20I%20doing%20wrong%20please%3F%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%2C%3C%2FP%3E%3CP%3EJulia%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2692864%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2692889%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%20Error%20-%201st%20time%20poster%2C%20please%20be%20gentle!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2692889%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1139554%22%20target%3D%22_blank%22%3E%40jmc74%3C%2FA%3E%26nbsp%3BUse%20the%20Number%20option%2C%20but%20note%20that%2090%25%20%3D%200.9%20and%2060%25%20%3D%200.6.%20change%20accordingly%20and%20it%20shall%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi, I'm trying to conditionally format a cell so it shows a traffic light according to result, simple.

% 90+ = green

between 60-90 = Yellow

Less than 60 = Red

I've tried both with per cent and number options and neither are giving me the correct result which should be yellow? What am I doing wrong please?

Thank you in advance,

Julia

2 Replies
best response confirmed by jmc74 (New Contributor)
Solution

@jmc74 Use the Number option, but note that 90% = 0.9 and 60% = 0.6. change accordingly and it shall work.

Thank you so much! Knew it would be such a simple answer. Really appreciate the swift response.