Conditional formatting using formulas and color coding

%3CLINGO-SUB%20id%3D%22lingo-sub-1716528%22%20slang%3D%22en-US%22%3EConditional%20formatting%20using%20formulas%20and%20color%20coding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1716528%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20understand%20how%20to%20apply%20color%20coding%20to%20conditional%20formatting%20within%20my%20business%20budgets.%20For%20example%2C%20comparing%20certain%20cells%20to%20the%20budgeted%20cell%2C%20then%20green%20meaning%20above%2C%20red%20meaning%20below.%20I%20have%20read%20through%20tutorials%2C%20sort%20of%20confused.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1716528%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-1716547%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20using%20formulas%20and%20color%20coding%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1716547%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F810252%22%20target%3D%22_blank%22%3E%40sbrown11%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20better%20to%20illustrate%20on%20example%20if%20you%20provide%20sample%20file.%20Otherwise%20it'll%20be%20repeating%20of%20tutorials%20you%20read.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I am trying to understand how to apply color coding to conditional formatting within my business budgets. For example, comparing certain cells to the budgeted cell, then green meaning above, red meaning below. I have read through tutorials, sort of confused.

2 Replies
Highlighted

@sbrown11 

That's better to illustrate on example if you provide sample file. Otherwise it'll be repeating of tutorials you read.

Highlighted

@sbrown11 

 

There is a lot of literature on conditional formatting and lots of videos on youtube. The possibilities in conditional formatting are very extensive, so you need a lot of time to invest in learning.
But if you have something specific in mind with your workbook / sheet / table then send a file (without sensitive data) and explain what exactly you want to accomplish. There will surely be someone who wants to and can help.

 

Here is just a small example of what you can find on the internet to get you started.

Conditional Formatting

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)