Right, iv been having some problems that i thought i had solved until i realised that you can only have 3 entries in the conditional forwarding.
Heres the scenario:
I have a large table of data, of which each entry is categorised as either A,B,C,D or W.
Now, so far i have sorted A,B & C so that if ($M2="??"), where ?? is either A,B or C, it will highlight that whole row either green, cyan or blue.
I have allowed D to stay blank giving me 4 colour options for the category.
However i am left with "W". The only other idea i have had is that i could possibly make the spreadsheet recognise rows with "W" in the Category field, then extract them to a table setup in Sheet 2.
Could anyone please recommend a method to allow me to do this, or perhaps suggest a simpler maybe more effective manner of solving my problem.
Any help would be greatly appreciated.
Richard
Heres the scenario:
I have a large table of data, of which each entry is categorised as either A,B,C,D or W.
Now, so far i have sorted A,B & C so that if ($M2="??"), where ?? is either A,B or C, it will highlight that whole row either green, cyan or blue.
I have allowed D to stay blank giving me 4 colour options for the category.
However i am left with "W". The only other idea i have had is that i could possibly make the spreadsheet recognise rows with "W" in the Category field, then extract them to a table setup in Sheet 2.
Could anyone please recommend a method to allow me to do this, or perhaps suggest a simpler maybe more effective manner of solving my problem.
Any help would be greatly appreciated.
Richard