Changing colour of a cell based on several conditions

[jennapayne]

Hi,

I am trying to change the colour of a cell and I would like it to return different colours for each of 9 different people. I also need it to only change colour if the date heading that column is between a range of dates in that row. I can post a table to illustrate this if that's possible but not sure how to do it!

Thanks,

Jenna

[Sadath31]

Yes, possible
pls post your file

[Labrat407]

I use this in the objects of the page.

Please Login or Register  to view this content.

Hope this can help you. I am working on changing this to use a named range and a loop for the initials so it is easier to modify by the other users.