Hello,
I need to shade a cell based on a date range. I tried to use the Conditional Formatting "between" but I am not getting it right.
Example:
I have 3 columns: Margin Rate; From Date; To Date
I need to color "Margin Rate" if today's date is between the "From Date" and "To Date".
Please see attached example
thank you
EE_ConditionalFormat.xlsx