My table has a unique date in each column from left to right. What formula
would automatically format/fill the entire column (e.g. A1:A50) if the cell
with the date = TODAY and then replicate itself for each column therafter?
Obviously, if the date < TODAY, it remains unformatted.