Novice user

%3CLINGO-SUB%20id%3D%22lingo-sub-1501298%22%20slang%3D%22en-US%22%3ENovice%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1501298%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20building%20a%20remodel%20budget%20tracker%20and%20I%20would%20like%20to%20manage%20the%20budget%20with%20visual%20indicators%20based%20on%20the%20over%2Funder%20result.%20So%20if%20I%20have%20a%20budget%20of%20%24500%20and%20I%20am%20over%20budget%20by%20%2450%20I%20want%20to%20turn%20the%20cell%20red%20and%20display%20the%20actual%20value.%20If%20I%20am%20under%20budget%2C%20the%20cell%20would%20be%20green.%20Is%20this%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%3C%2FP%3E%3CP%3EArt%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1501298%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-1501366%22%20slang%3D%22en-US%22%3ERe%3A%20Novice%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1501366%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F715526%22%20target%3D%22_blank%22%3E%40ArtAartformcovegmail%3C%2FA%3E%26nbsp%3BThis%20is%20done%20by%20what's%20called%20Conditional%20Formatting.%20You%20can%20read%20more%20about%20it%20here%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.excel-easy.com%2Fdata-analysis%2Fconditional-formatting.html%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.excel-easy.com%2Fdata-analysis%2Fconditional-formatting.html%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20good%20start%20to%20learn%20what%20can%20be%20done%20and%20how.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1501534%22%20slang%3D%22en-US%22%3ERe%3A%20Novice%20user%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1501534%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20providing%20the%20link%20for%20me%20to%20go%20fish!%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BI%20was%20over%20complicating%20the%20effort.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello!

 

I am building a remodel budget tracker and I would like to manage the budget with visual indicators based on the over/under result. So if I have a budget of $500 and I am over budget by $50 I want to turn the cell red and display the actual value. If I am under budget, the cell would be green. Is this possible?

 

Thanks in advance!

Art

2 Replies

@ArtAartformcovegmail This is done by what's called Conditional Formatting. You can read more about it here:

https://www.excel-easy.com/data-analysis/conditional-formatting.html 

 

A good start to learn what can be done and how.

Thank you for providing the link for me to go fish! @Riny_van_Eekelen I was over complicating the effort.