Home

Multiple Conditional Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-777934%22%20slang%3D%22en-US%22%3EMultiple%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-777934%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20figure%20out%20how%20to%20do%20a%20conditional%20formatting%20with%20color%20fill%20and%20add%20text.%20Ex.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20formula%20in%20cell%20B5%20gets%20deleted%20then%20I%20need%20the%20cell%20to%20turn%20blue%20and%20the%20cell%20to%20say%20%22No%20Formula%22%20is%20this%20possible%3F%20If%20so%20how%20do%20I%20do%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-777934%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-777971%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-777971%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383886%22%20target%3D%22_blank%22%3E%40ahord05%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3EYou%20are%20combining%202%20different%20functionalities%3A%3C%2FP%3E%3CP%3EChanging%20the%20color%20of%20the%20cell%20based%20on%20whether%20it%20has%20contents%20or%20no%20%26gt%3B%26gt%3B%20This%20is%20Conditional%20formatting%3C%2FP%3E%3CP%3EDelivering%20a%20string%20of%20text%20%26gt%3B%26gt%3B%20This%20is%20a%20conditional%20IF%20function%20and%20should%20be%20created%20in%20a%20different%20cell%20other%20than%20the%20one%20you%20are%20evaluating.%3C%2FP%3E%3CP%3EI%20attached%20a%20sample%20file%20with%20the%20functionalities%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20459px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F124837iE02D9C00E833D5CA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Two%20functionalities.png%22%20title%3D%22Two%20functionalities.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ECheck%20it%20in%20Excel%3C%2FP%3E%3CP%3EHope%20that%20Helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-778205%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-778205%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383886%22%20target%3D%22_blank%22%3E%40ahord05%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20the%20task%20is%20to%20check%20if%20in%20some%20cell%20formula%20was%20changed%20on%20value%2C%20when%20better%20to%20use%20conditional%20formatting%20rule%20with%20the%20formula%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-ruby%22%3E%3CCODE%3E%3DISFORMULA(B1)-1%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20591px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F124867i52FB102CDB56B45D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
ahord05
Occasional Visitor

I need to figure out how to do a conditional formatting with color fill and add text. Ex.

 

If the formula in cell B5 gets deleted then I need the cell to turn blue and the cell to say "No Formula" is this possible? If so how do I do it?

2 Replies

@ahord05 

Hi

You are combining 2 different functionalities:

  • Changing the color of the cell based on whether it has contents or no >> This is Conditional formatting
  • Delivering a string of text >> This is a conditional IF function and should be created in a different cell other than the one you are evaluating.

I attached a sample file with the functionalities

Two functionalities.png

Check it in Excel

In column B there is a conditional formatting that changes the cell color to blue if contents are deleted

In column C there is an IF function that returns the text "No Content" if the cell to it's left is blank.

Both functionalities are triggered by deleting any cell content in column B

Hope that Helps

Nabil Mourad

@ahord05 

If the task is to check if in some cell formula was changed on value, when better to use conditional formatting rule with the formula

=ISFORMULA(B1)-1

image.png

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies