Nprinting Problem with Conditional formatting moving to other cells
When applying conditional formatting to a cell eg $B$8 using both rules 'Format only cells that contain' or 'Use a formula to determine which cells to format' to get red and green background fills based on a value or formula. The previewed result is applied randomly to other columns as well?
The 'keep source format' for the table I am using is unchecked.
