Cond formatting help.

[rumkus]

Hi All

How can I apply cond.formatting below ?

If col A and col B empty no format
If both col A and col B with data no format
If only one of them is with data then formatted

Thank you very much in advance.

 

[Dave Peterson]

With A1:Bxxx selected and A1 the active cell

Format|conditional formatting
formula is:
=counta($a1:$b1)=1

 

[rumkus]

Thank you Dave.

 

[rumkus]

Sorry for calling again I have spend quite a lot of time but no
success.
How can I apply the same logic if I have 4 or 5 columns.

Thank you

 

[fatturtle]

I don't have excel at home so I'm going from memory but

counta(A1:A4)<2 or however many null cells you want

you have to be sure the cells have nothing in them (including
deliberate/text nulls)

I've done exactly what you're looking for using counta but you may have
to play a little with it

 

[rumkus]

Thank you for your kind response.

I have finally adapted Dave's help above to my needs:
Either leave blank or complete the record else just know colored
rows will be deleted.


=AND(COUNTA($A2:$F2)<>6,COUNTA($A2:$F2)<>0)


Thank you very much indeed



fatturtle yazdi: