I am having a nightmare with what should be a straight forward task.
I have created two conditional formatting rules - which work (they change colour) but it makes no sense as to why?
These are the formulas:
I want them to look at two lists I have created "Salvage" and "Suppliers" then flag them in the colours.
Excel accepts the formulas but all the cells end up formatted wrong, so Kirkcaldy is not on the suppliers list so should not be in red type.
Am I missing something obvious as I have been working on this for hours and getting nowhere!
Thank you for taking the time to look
Sara
I have created two conditional formatting rules - which work (they change colour) but it makes no sense as to why?
These are the formulas:
Delivery Schedule TEMPLATE UPDATED 210221.xlsm | |||
---|---|---|---|
K | |||
2 | KIRKCALDY | ||
Delivery Schedule Stoke |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
K2:V101 | Expression | =COUNTIF(OUTPUT!K:V,Suppliers)>0 | text | NO |
K2:V101 | Expression | =AND(K2<>"",MATCH($K2,SALVAGE,0)) | text | NO |
I want them to look at two lists I have created "Salvage" and "Suppliers" then flag them in the colours.
Excel accepts the formulas but all the cells end up formatted wrong, so Kirkcaldy is not on the suppliers list so should not be in red type.
Am I missing something obvious as I have been working on this for hours and getting nowhere!
Thank you for taking the time to look
Sara