Forum Discussion
Conditional formatting
Wyn,
No, this highlighted everything except what it should have. I am working on a Travel spreadsheet and I need to be alerted if the employee is traveling during the same date as already recorded. (To prevent being paid twice for paperwork error).
So both the name (column B) and the date range (column C) - in the same row, need to repeat exactly as in another row to result in a change of color fill to alert us that something may not be right.
(Did I explain that better?)
Ah, so in that case
In D1 type =COUNTIFS(B:B,B1, C:C,C1)>1
Copy this down
This will give true whenever there is more than 1 entry with those 2 combinations
You can then reference the cell D1 in the same way as mentioned earlier with the conditional formatting
Thank you! Awesome stuff, Excel is. (And so are those who understand it!)
- You're welcome