Forum Discussion
SarahBevan
Jul 03, 2020Copper Contributor
Conditional Formatting not working on new sheet
Hello, This one has me stumped. I was using the same formula on another sheet and was working with 98% success. New sheet, cleared all conditional formatting rules and the re-entered the formula ...
Riny_van_Eekelen
Jul 03, 2020Platinum Contributor
SarahBevan Change the cel references in the rules from F3 and B3 to F1 and B1 or set the applied range to start in F3. Now, you are applying the rules starting on row 3 for the entire column F (thus starting in row 1). All the conditional formats are now shifted up two rows.