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