Tag Info

New answers tagged


Although you mention only A2 in sheet March I'm guessing you may want equivalent formatting throughout ColumnA, so start by selecting ColumnA then: Format, Conditional formatting..., Custom formula is: =match(A1,indirect("Roster"&"!D:D"),0)>0 select yellow (Range: should be A:A) and Save rules. For each colour you need a separate rule ...

Top 50 recent answers are included