Excel Conditional Formatting Based On Two Different Cell Values

Excel Templates: https://calonheindel.etsy.com/

NEED EXCEL HELP? Check out my Fiverr business...
https://www.fiverr.com/share/qlYjK9

Music (Epidemic Sound): https://share.epidemicsound.com/64td0d

Microsoft Office: https://amzn.to/3czZiW7

Learn how to automatically format cells based on two different cell values. As well as update when the latest or newest entry in a row is added.

This is a bit more complicated to achieve, but this video will show you everything you need to do. I use two different helper columns to create the correct conditional formatting. This video will show how to create the desired formatting for an entire row based off the last entry. Overall this will show you how to create conditional formatting for an entire row based off one or more different cell values or conditions.

This a much more advanced method to conditionally format cells. This method could be applied to more than two different cell values. If you enter new data this conditional formatting will automictically apply to all the other cells. Its all based on the last entry you input into the data set. Based of the most recent entry each row will be formatted or highlighted with any duplicates throughout the entire data set. There are two helper columns that end up getting hidden that help accomplish this. One of the helper columns has a much more complicated and advanced formula to get the correct formatting to occur.

Disclaimer & Full Disclosure: We are a a participant in the Amazon Associates Program, So If you purchase something from our affiliate links will get a small commission with no extra cost to you. This makes it possible for us to keep producing VIDEOS!
°We NEVER collect, store, use, or have access to any data about you.