Conditional Formatting

  • Thread starter Thread starter Mike Collard
  • Start date Start date
M

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
 
Mike

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

Gord Dibben Excel MVP
 
Back
Top