Forum Discussion
Solved
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...
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!
