# I am using the formula below below but only green color in cell BK=59 not BK=65

1. ## I am using the formula below below but only green color in cell BK=59 not BK=65

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  Register To Reply

2. ## Re: I am using the formula below below but only green color in cell BK=59 not BK=65

i'm a little lost on the explanation here

you want to apply the colour to BK59 and BK65 Only

so if you highlight/select both the Bk59 and BK65 - that will be the applies to range
and then use
(=AND(COUNT(\$H65:\$I65)=2;J\$5>=\$H65;J\$5<=\$I65))
what colour condition is that for ? green

rather than attach an image attach the actual spreadsheet - just make sure its all dummy data and can be on a public forum  Register To Reply