Forum Discussion
Conditional formatting based on a Table column header
Hi, I ran into an odd behavior in Excel displayed in the following screenshot: In column A, we have a set of dates ordered ascendingly (in the format dd/mm/yyyy) formatted as a table with a head...
=A2<TODAY()This rule returns the intended result. The rule must reference the leftmost cell of the first row of the applies to range. Since applies to =$A$2:$A$14 the rule must reference A2. For example if the applies to range is $D$7:$H$25 we would have to reference cell D7 in the rule for conditional formatting.