Hello all,
In my sheet attached, I want cells V16 to AH 16 to be highlighted in Pink if it matches the text after Z20 i.e P8
I want cells V16 to AH 16 to be highlighted in Green if it matches the text after Z20 i.e P6
I know this is conditional formatting and a custom rule is needed but unsure how to write this to say match the text after : symbol.
pPlease can someone help?
thank you
Bookmarks