Skip to playerSkip to main content
In this video we will cover how to highlight duplicate adjacent cell in Google sheet.

Highlight Duplicate Adjacent Cell
1) Select dataset
2) Format ~ Conditional Formatting
3) Custom formula is
4) =COUNTIFS($B$5:$B,$B5,$C$5:$C,$C5)>1


How to highlight cell based on adjacent cell value in Google Sheets?,How do I highlight repeated cells in Google Sheets?,How do I highlight a cell in Google Sheets based on another cell?,How do I highlight a cell if the same value exists in another column in Google Sheets?,

Check out my complete suite of Microsoft Excel Tips and Tricks.
https://www.youtube.com/@jjnet247/shorts
https://www.tiktok.com/@exceltips247
https://www.instagram.com/exceltips247/
https://www.dailymotion.com/ExcelTips247
https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/
https://x.com/ExcelTips247/media
https://www.reddit.com/r/Excel247/
https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks

Category

📚
Learning

Recommended