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 H I have their Shrinkage %
Each brand has a different target.
I need the entire row to be coloured, aside from manually colouring them, I am hoping there might be a nifty conditional formatting formula out there.
Thank you in advanced.
Jasmin
You can use these formulas in Conditional Formatting: (adjust the range according to your file)
GREEN:RED:PHP Code:=OR(AND($A2="A",$H2<=0.5%),AND($A2="B",$H2<=2%),AND($A2="C",$H2<=1.5%))
PHP Code:=NOT(OR(AND($A2="A",$H2<=0.5%),AND($A2="B",$H2<=2%),AND($A2="C",$H2<=1.5%)))
Life unfolds as we shape it.
Thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks