Relative Content

Tag Archive for vbaexcel-formulaexcel-2010conditional-formatting

Need VBA code and syntax to automate Conditional Formatting across multiple columns

My goal is to find the UNIQUE MINIMUM value in each COLUMN having a Range D2:D13, E2:E13….. to V2:V13, with the EXCEPTION of Colum M. (This is 19 columns, skipping the 10th column). Each cell in the Range D2:V13 is light blue formatted, and I want to highlight the UNIQUE MINIMUM for each COLUMN….if there is a UNIQUE MINIMUM. Each cell with a UNIQUE MINIMUM will be WHITE an all others in that column will remain the light blue. All help would be much appreciated.