Forum Discussion
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...
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.