Needing some assistance from the guru's, please!
I have a spreadsheet with over 500 lines of stores stocktake results for 3 brands in one workbook.
Example:
Brands, A, B & C in column A
In Column B I have their Shrinkage %
Each brand has a different target.
Aside from manually colouring them, I am hoping there might be a nifty conditional formatting formula out there.
Thank you in advanced.
Jasmin
Screenshot 2025-02-18 220130.png
If you change the Target column to just the percentages, you could use VLOOKUP to get the target shrinkage for the brand and compare that to the actual shrinkage. You'll need two CF formulae; one for red and one for green. Or, you could default to green and just CF red.
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks