Forum Discussion
Conditional formatting
I am brand new to Excel, thrown directly into the deep end with a new job only three months ago. I have found it is incredibly cool, but the directions at times can be very mind-boggling.
I hav...
Ideally add an additional column and then use a formula =B1=C1 that will show True where they match or False where they don't.
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
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
Thank you! I will try this right now.
This is for Travel and I need to be alerted if the name AND the date range repeat.
Let's see how this works.