Conditional Formatting

[Vicphuket]

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 name are filled in weekly with a number if they have participated . The formula takes the 9 largest numbers in each row and highlights them. However for the formula to work I need to fill the sheet with Zero's and until there are 9 whole numbers in a row it also highlights the the Zero's. Is it possible to highlight the Zero's that are included in the formula without affecting the original conditional formatting

=E3+COLUMN(E3)%%%>=AGGREGATE(14,6,$E3:$AD3+COLUMN($E3:$AD3)%%%,9)

[#2]

@Vicphuket 

Your sample workbook is completely empty...

[#3]

The attaches sheet is BLANK,, please load some data along with the formula you have applied,,, and the expected area for CF.

[#4]

@Vicphuket 

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.