Conditional formatting

[Snowsride]

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

Any help appreciate

 

[JulieD]

Hi

choose "formula is" and then type
=AND($C1<>"",$D1<>"")
where C & D are your columns

and set your format

let us know how you go

Cheers
JulieD

 

[Jacques Brun]

With the following conditional formating in range A1:A10
Formula =(Abs(A1)+Abs(B1)<>0)
Format : Red pattern
Any of the Ax cells in range A1:A10 becomes red if :
either Ax not null
or Bx not null
or both are not null

The Abs is to avoid that with Ax=-3 and Bx=+3 Ax is not
turned to red.

If by null you don't mean zero but empty, consider the
following formula =(Len(A1)+Len(B1)<>0) the format will
applies as soon as one of the Object or Adjoining cell is
not empty.

Hope it addresses your problem

Regards
Jacques

 

[Mike Collard]

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

Regards

Mike