Working With Named Ranges In Excel

Just name the source cell or range, and use the defined name in the Conditional Formatting formulas. CF won't object, and everything will work as you expect. VBA Procedure For Working With Names. Adding A Range Name . You can use the Add method of the Names collection object to add a new defined name. ThisWorkbook.Names.Add Name:="NewName", _ ................
................