Forum Discussion
Excel formatting issue
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 have a spreadsheet and what I want to do is highlight a cell if BOTH column B AND column C (in the same row) repeat.
It is 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?)
Can anyone help me?
Hi,
- Select the B and C columns
- Apply new condition formatting rule
- Use the option - "Use a formula to determine which cells to format
- Use the below formula:
=COUNTIFS($B:$B,$B1, $C:$C,$C1)>1
- Click on Format button and select a fill color of your choice
You should be all good.
See the example screen shot below:
Hi,
- Select the B and C columns
- Apply new condition formatting rule
- Use the option - "Use a formula to determine which cells to format
- Use the below formula:
=COUNTIFS($B:$B,$B1, $C:$C,$C1)>1
- Click on Format button and select a fill color of your choice
You should be all good.
See the example screen shot below:
Thank you so much! It works perfectly!
