Home

Conditional formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-847885%22%20slang%3D%22en-US%22%3EConditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-847885%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20new%20here!%3C%2FP%3E%3CP%3EUntil%20now%20in%20my%20excel%20charts%20I%20was%20able%20to%20color%20cells%20using%20formulas%20in%20the%20cells%20-%20now%20it%20doesn't%20work.%20Eg.%20I%20use%20%22If%22%20condition%20to%20show%20%221%22%20when%20the%20result%20is%20right%2C%20there%20is%20no%20result.%20But%20if%20I%20write%201%20directly%2C%20the%20Conditional%20formatting%20works.%20Any%20idea%20about%20it%20from%20somebody%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-847885%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-847895%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-847895%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F406903%22%20target%3D%22_blank%22%3E%40dsd74%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20sure%20what%20exactly%20you%20are%20trying%20to%20achieve%20here.%20Why%20not%20share%20a%20sample%20workbook%20to%20visualize%20the%20issue%20you%20are%20having%3F%3C%2FP%3E%3CP%3EBtw%2C%20in%20your%20IF%20formula%2C%20if%20you%20placed%20double%20quotes%20around%201%20like%3CSTRONG%3E%221%22%3C%2FSTRONG%3E%2C%20remove%20the%20double%20quotes%20and%20just%20type%20%3CSTRONG%3E1%3C%2FSTRONG%3Ein%20the%20IF%20formula%20and%20see%20if%20that%20works%20for%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E
dsd74
Occasional Visitor

Hi, I am new here!

Until now in my excel charts I was able to color cells using formulas in the cells - now it doesn't work. Eg. I use "If" condition to show "1" when the result is right, there is no result. But if I write 1 directly, the Conditional formatting works. Any idea about it from somebody?

1 Reply
Highlighted

@dsd74 

Not sure what exactly you are trying to achieve here. Why not share a sample workbook to visualize the issue you are having?

Btw, in your IF formula, if you placed double quotes around 1 like "1", remove the double quotes and just type 1 in the IF formula and see if that works for you.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies