SOLVED
Home

Help with Conditional Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-786098%22%20slang%3D%22en-US%22%3EHelp%20with%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-786098%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20table%20that%20also%20has%20a%20design.%20It%20gets%20stats%2Fnumbers%20from%20another%20table%20and%20calculates%20them%20on%20this%20one.%20Some%20cells%20are%200.%20I'd%20like%20to%20not%20show%20those%2C%20I%20was%20thinking%20of%20doing%20conditional%20formatting%20to%20change%20the%20colors%20of%20all%20cells%20that%20are%200%20but%20I'm%20not%20sure%20how%20to%20with%20the%20rows%20having%202%20different%20colors.%3C%2FP%3E%3CP%3EI%20tried%20multiple%20things%20but%20so%20far%20it%20hasn't%20worked.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-786098%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-786330%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20with%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-786330%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F386505%22%20target%3D%22_blank%22%3E%40Pronoia%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20hide%20zeroes%20without%20conditional%20formatting%3C%2FP%3E%0A%3CP%3E-%20uncheck%20this%20setting%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125449i979ECFE120AA1756%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E-%20or%20apply%20custom%20number%20format%20like%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-ruby%22%3E%3CCODE%3EGeneral%3BGeneral%3B%3B%40%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Eto%20your%20cells%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125450i9723B31C2488B707%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_1.png%22%20title%3D%22clipboard_image_1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Pronoia
Occasional Visitor

I have a table that also has a design. It gets stats/numbers from another table and calculates them on this one. Some cells are 0. I'd like to not show those, I was thinking of doing conditional formatting to change the colors of all cells that are 0 but I'm not sure how to with the rows having 2 different colors.

I tried multiple things but so far it hasn't worked.

1 Reply
Solution

@Pronoia 

You may hide zeroes without conditional formatting

- uncheck this setting

clipboard_image_0.png

- or apply custom number format like

General;General;;@

to your cells:

clipboard_image_1.png

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 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
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
12 Replies