greater than 3 conditional formats WITH an IF statment using VBA

Hi,

I have used the following code to have more than 3 conditional formats before....

Please Login or Register  to view this content.

However I now need to add an if statment to it, this is where my problem lays...

I have 2 differnt sets of targets for the same metric. One is a grad bay agent, the other is a non grad bay agent. click link for a test sheet Test sheet excel forum.xls

So although the 2 differnt types of agent appear in the same list, there targets and hence the conditional format (determined by the target deck tab) are different, hence a grad agent and a non grad agent can have the same acheivment in say 38 day retention, but one should be conditionally formated green as they are in grad bay, but the non grad bay agent with the same acheivment will be say yellow, as this is where they fall in the non grad target deck....

hope this makes sence thus far!

if not please ask and ill try to explain in more detail!

had this in my "to-do" list now for like 2 weeks and my boss is chasing me for it... YAWN...

any help really appreciated!

thanks

James

Sorry,

I must be missing something? are ozgrid and excelforum the same then? I have had to sign up to this forum separatly from ozgrid?

Im just trying to reach as many folk as possible? why cant I cross post on 2 (as far as I can tell) separate forums?

Am I to link every forum I post on, on each forum? this seems a little.... strange?

thanks

James

Hi James,

welcome to the forum. You can cross-post, just provide a link to the other thread, so people don't do unnecessary work.

http://www.excelguru.ca/content.php?...-cross-posters