Avatar of pdvsa
pdvsa
Flag for United States of America

asked on 

Shade a cell based on date range

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
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
pdvsa

8/22/2022 - Mon