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

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