Quote:
Originally Posted by cwkotch
Yup, I did follow correctly. still it only highlighted the cell containing todays date
|
1. You want to make sure you're applying the conditional formatting to the whole area, not just the date column. So if your data is in A to F and rows 2 through 50, highlight them all before applying the conditional formatting. And make sure when you select the area, work from the top down, not the bottom up. From what I've noticed, it matters.
2. When you write the formula, follow Pecoflyer's example [=$A1=today()] in that the dollar sign is only on the column, not the row. So, no matter which column you're applying the conditional formatting in, it's based on the condition of the date in column A (the dollar sign makes that absolute) but relevant to each row separately (row not absolute bur relative.)