Conditional Formatting- Linking to different cells

Please purchase the course before starting the lesson.

You do not have to limit yourself to simple conditional formatting where it only changes colour if the cell it is on meets some condition. So if you have a cell that indicates that the row is a duplicate, you can make the entire row change colour.  Below the Yes/ No drives whether the entire row should change colour

Back to: Advanced Excel Course > Conditional Formatting