Forum Discussion
Conditional formatting
Then you can highlight B1 to C100 for example and click Home > Conditional Formatting > New Rules > Use Formula
And in the formula box type =$D1 (this $ means that both the result in B and C will flag )
And apply a format
Alternatively if you can't add an extra column
Then you can highlight B1 to C100 for example and click Home > Conditional Formatting > New Rules > Use Formula
And in the formula box type =$B1=$C1
Again apply a format
Hope that helps
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