Forum Discussion
Vicphuket
Sep 18, 2020Copper Contributor
Conditional Formatting
I am using this formula to Conditionally format a worksheet. The sheet consists of a list of names vertically, top row horizontally every Tuesday for 6 months. The corresponding cells against each n...
SergeiBaklan
Sep 18, 2020Diamond Contributor
To force blank cells as zeros in formula you may use double dash as
--($E3:$AD3+COLUMN($E3:$AD3)%%%) in that part of the formula.