Sep 16 2019 10:04 AM
Dear all,
PLEASE I need some help. I tried many times, I want a cell to be pink since initial date til final date, but it doesn't worked. =$F$4:$AI$4>=$F$4:$AI$4<=$D$5
I think my excel book is having problems . I am attaching the file.
@Nauthstar Could you help me please or some else ? I really want to learn how to do it.
Many thanks
Otilia
Sep 16 2019 10:25 AM - edited Sep 16 2019 10:26 AM
Delete all your existing conditional formatting rules first.
And then select the range F5:AI5 and make a New Rule for Conditional Formatting using the formula given below and set the format as per your choice.
=F$4<=$D5