Oct 14 2020 11:33 AM
Oct 14 2020 12:44 PM
If you were to place the formula in the top-left cell of the CF range, it should reference the cells you wish to test and return TRUE/FALSE. Filling down or across would generate a pattern of TRUE/FALSE that corresponds to the pattern you expect to see.
Use the formula from the top left cell to define the new conditional format. Reinstate any formulas/values in the CF range you may have lost while developing the CF conditions..