Magic Scientist Excel Brain Help? If B2-P2 are blank (and) Q2 isn't then make A1 fill red

Originally Posted by FDibbins

that wont work, try this instead...
=AND(counta(B2:P2)=0,Q2<>"")

Hi Ford, tested formula in post#2 with yours and both yielding same result.
Did I miss out something



_______________________________________________________________________________________________________________________________
1. Click on the * Add Reputation if you think someone helped you
2. Mark your thread as SOLVED when question is resolved

Alvin