Rather than continue to spot check large numbers randomly (and wait several hours for the results), I thought I'd go to the community with this one. It took approximately 6 seconds to write 1,000 rules, 3 minutes to write 5,000 rules, and about 23 minutes to write 10,000 rules. It should be noted that the time it took to run the macro appeared to increase exponentially. However, anything more than 5,000 caused my file to crash when editing a cell. I was able to write at least 10,000 individual rules for one cell. MsgBox "There was an Error: " & Chr(10) & Err.Number & ", " & Err.Description, vbExclamation With (xlCellValue, Operator:=xlEqual, Formula1:=Text(i)) So, in order to find out if there was a maximum in Excel 2016, I wrote a macro to create thousands of conditional formatting rules: Sub CondForm() It seems in earlier versions, the maximum number of conditional formatting rules was 3. In my research I did find references to Excel 2007 and earlier ( here and here), but no references to later versions of Excel. Inspired by this question, I went down a rabbit hole trying to discover the maximum allowable number of conditional formatting rules that can be applied to a cell.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |