Conditional Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-2433369%22%20slang%3D%22en-US%22%3EConditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2433369%22%20slang%3D%22en-US%22%3E%3CP%3EMorning%20Guys%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20help%20out%2C%20I%20am%20trying%20to%20build%20a%20simple%20to%20look%20at%20inventory%20tracker%20so%20any%20stock%20that%20falls%20to%20or%20below%20a%20certain%20level%20can%20be%20easily%20spotted.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20table%20of%20data%20and%20want%20to%20highlight%20the%20row%20if%20the%20value%20in%20Colum%20E%20(current%20stock)%20is%20equal%20or%20less%20to%20the%20value%20in%20Colum%20G%20(Min%20Stock%20Holdings)%20and%20also%20add%20a%20flag%20icon%20to%20Colum%20A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anybody%20have%20know%20a%20formula%20that%20would%20be%20able%20to%20achieve%20these%20results%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JohnCooper00000_0-1623296944637.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F287765i9E8BB0A2C47D41B9%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22JohnCooper00000_0-1623296944637.png%22%20alt%3D%22JohnCooper00000_0-1623296944637.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2433369%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-2433408%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2433408%22%20slang%3D%22en-US%22%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1075306%22%20target%3D%22_blank%22%3E%40JohnCooper00000%3C%2FA%3E%20%2C%3CBR%20%2F%3E%3CBR%20%2F%3Efor%20sure%2C%20that's%20easy.%3CBR%20%2F%3E%3CBR%20%2F%3ECheck%20out%20the%20following%20page%2C%20its%20simple%20to%20understand%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.excel-easy.com%2Fdata-analysis%2Fconditional-formatting.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.excel-easy.com%2Fdata-analysis%2Fconditional-formatting.html%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EBest%20regards%2C%3CBR%20%2F%3ESchnittlauch%3CBR%20%2F%3E%3CBR%20%2F%3E%22First%2C%20No%20system%20is%20safe.%20Second%2C%20Aim%20for%20the%20impossible.%20Third%2C%20no%20Backup%2C%20no%20Mercy%22%20-%20Schnittlauch%3CBR%20%2F%3E%3CBR%20%2F%3EMy%20answer%20helped%20you%3F%20Don't%20forget%20to%20leave%20a%20like.%20Also%20mark%20the%20answer%20as%20solved%20when%20your%20problem%20is%20solved.%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2433409%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2433409%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1075306%22%20target%3D%22_blank%22%3E%40JohnCooper00000%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEdit%3A%20A%20quick%20and%20dirty%20code%20for%20the%20Order%20reflag%20is%20this%20one%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIf(F7%26lt%3B%3DH7%3B%22Alarm%22%3B%22No%20Problem%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20dont%20want%20to%20be%20disturbed%20by%20the%20%22No%20Problem%22%20you%20can%20also%20let%20it%20free%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2433410%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2433410%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1075306%22%20target%3D%22_blank%22%3E%40JohnCooper00000%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20got%20you%20fam.%20use%20conditional%20formatting%20to%20do%20all%20the%20fancy%20stuff%2C%20also%2C%20you%20should%20just%20add%20another%20column%20to%20categorize%20your%20hardware.%20It%20will%20make%20it%20so%20much%20easier%20for%20analytics%20and%20automation.%20Formula%20in%20A1%2C%20like%20the%20guy%20above%20me%20said.%20I%20use%201s%20and%20-1s%20to%20make%20conditional%20formatting%20easier.%20Happy%20to%20help%20if%20you%20need.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Regular Visitor

Morning Guys

 

Can anyone help out, I am trying to build a simple to look at inventory tracker so any stock that falls to or below a certain level can be easily spotted.

 

I have a table of data and want to highlight the row if the value in Colum E (current stock) is equal or less to the value in Colum G (Min Stock Holdings) and also add a flag icon to Colum A

 

Does anybody have know a formula that would be able to achieve these results ?

 

JohnCooper00000_0-1623296944637.png

 

 

 

5 Replies
Hi @JohnCooper00000 ,

for sure, that's easy.

Check out the following page, its simple to understand

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

Best regards,
Schnittlauch

"First, No system is safe. Second, Aim for the impossible. Third, no Backup, no Mercy" - Schnittlauch

My answer helped you? Don't forget to leave a like. Also mark the answer as solved when your problem is solved.

@JohnCooper00000 

 

Edit: A quick and dirty code for the Order reflag is this one:

=If(F7<=H7;"Alarm";"No Problem")

 

If you dont want to be disturbed by the "No Problem" you can also let it free

@JohnCooper00000 

 

I got you fam. use conditional formatting to do all the fancy stuff, also, you should just add another column to categorize your hardware. It will make it so much easier for analytics and automation. Formula in A1, like the guy above me said. I use 1s and -1s to make conditional formatting easier. Happy to help if you need.

 

 

@JohnCooper00000 As a variant, perhaps the attached file (just a quick-and-dirty mock-up) will help you apply CF to your own file.

 

Created on a Mac but similar on a PCCreated on a Mac but similar on a PC

Nicce, way to one up brah