I have Conditioned all cells to turn red when the date is past today's date but now I would like it to return a 0 instead of the date that is currently in the cell. All the cells are vlookup from other worksheets. Ideally I would like it to work out the percentage of how many cells are highlighted at the bottom.