Cells changing colour

[Ads1471]

Hi

I am after a formula that works please

If I have A and B. When a date is entered into A1 I want B1 to turn red. When a date is then entered into B1 I want both to turn green.

Thanks

 

[Ads1471]

so =AND(ISNUMBER(A1:B1),ISNUMBER(B1)) ???

 

[Fluff]

No leave the formula as it was.
Select conditional formatting > manage rules > look at the applies to range for that formula, what does it say?

 

[Ads1471]

it is

=$A$1:$B$1

 

[Fluff]

Ok, that's right, but the formula should be
=AND(ISNUMBER($A1),ISNUMBER($B1))
I forgot to lock the range

 

[Ads1471]

Brilliant, Thats worked. Thank you for your help on this I will remember you for future

 

[Fluff]

Glad to help & thanks for the feedback