Hi All,
I am struggling to work this one out. Hopefully I can explain.
I have two sheets. Sheet one contains a list of queries raised and each is put under a specific catagory. Sheet two contains a list of all the query catagories with a priority rating from 1 to 3 in another column.
What I want to do is highlight the list of raised queries on sheet one based on their priority on sheet two. The list of catagories contains over 400 entries and the priorities may change throughout the year so manually updating these isn't really an option.
Is there a way with do do this with conditional formatting? By looking for a match in the sheet two and the corresponding priority to colour either red/amber/green?
Thanks in Advance!
Bookmarks