Hi !
When I fill in date for my project in my example H=65 (22-Aug), I=65 (23-Aug) I want to use “Conditional Formatting” to fill in color in two cells BK=59 and BK=65.
I am using the formula below see picture below but only green color in cell BK=59 not BK=65
Have some one some tips what to do ?
Rule (=AND(COUNT($H65:$I65)=2;J$5>=$H65;J$5<=$I65))
Conditional Formatting Rules Manager (=$J$59:$GP$59;$J$65:$GP$65)
Br
Lars-Erik
Exel Formula.jpg
Bookmarks