Conditional Formatting

[Mike Collard]

I want to format a cell if it is not null and if an
adjoining cell is not null. So far I have been able to
either set a condition on the value of the subject cell OR
write a formula to test if the adjoining cell is not null
but I can't figure out how to combine the two conditions.

Any help appreciated

Mike Collard

 

[Gord Dibben]

Mike

Select A1 and Format>CF>Formula is: =AND(A1<>"",B1<>"")

Gord Dibben Excel MVP

 

[Mike Collard]

Thanks - I did in fact sus my formula was wrong.

Regards

Mike

 

[Snowsride]

Gord

I think we've met before!

Thanks for the feedback - problem solved.

Regard