Guru's,

Need help in doing conditional formatting based on data in other cells. Basically, Column A is a list of Cell Sites, Columns B and C would contain either dates tasks were completed on site, or be blank. I want to Conditional Format Column A to shade cell and font 1 color if only B or C has a date or another color if BOTH B and C have a Date.


"A" "B" "C"
ID Date 1 Date 2
1234
1235 4/2/2013
1236 1/22/2013
1237 1/23/2013 4/4/2013