Hi,

In A column, there are 100 employee names , they are daily used to send mails to me. I want to put conditional format, that Cell color has to change for all updated cells on daily basis.

Ex: First day 80 members send a mail. I updated random numbers in adjacent cell (B column) of all 80 people. Then a color (say Red) should apply to all those updated 80 cells automatically. On next day randomly 85 members send a mail. I updated random numbers in adjacent cells (B column) of all 85 people. then a color (this time say yellow) (If that cell contain Red color or none) should apply to all those updated 85 cells automatically. This process is on daily basis.

Pls help me