Forum Discussion
Using CHAR(COLUMN()+64) within Conditional Formatting
Hi, I have a need to highlight a set of cells based on whether or not a date (date is concatenated based on multiple other cells) =TODAY(). Heres the background: A1 = "2024" A2 through A61 ...
williamgurney For your consideration, I show an alternative, simpler conditional formatting rule, which depends on somewhat different content than your current worksheet. See the attached workbook, with notes on the _Info worksheet.
This is a beautiful piece of work! Thank you.
I will have to digest this over some time because you’re using stuff I’ve never touched before.
Thank you!
Thank you for those kind words. When you do get a chance to review the formulas in more detail, you can refer to the notes in this related, additional workbook.
