VBA Code: Macro to keep blank cells white when conditional formatting is set to highlight duplicates

JT Hughes 1 Reputation point

I currently have a Macro set to highlight cells with duplicate values. I can't seem to find the code to create a ConditionalFormatting to Format only cells that contain Blanks and change the fill to "No Fill".

Office Mac
Office Mac
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Mac: A family of Apple personal computers that run the macOS operating system.
319 questions
{count} votes