The conditional formatting macro you have just downloaded will format the “data2use” range by scanning “conditions2use” range and using the formats in “formats2use” range. Finally hit Alt+F8 (or menu > tools > macro > macros) and run the cFormat macro.See this illustration to understand how these 3 ranges are used to create more than 3 conditional formats: In your workbook, define 3 named ranges.ĭata2use: This range contains the cells to be formatted.Ĭonditions2use: This range is identical in shape and size to data2use and contains conditions for the data range start from 1 to n (n being the maximum number of conditional formats your would like to have)įormats2use: This range contains “n” cells each formatted in a way you would like to format the cells in data2use range.Just copy the VBA Macro cFormat() to your workbook or place it in wherever you keep all your macros. ![]() ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |