Conditional Format ISBLANK NOT AND IF ?? based on 2 cell values

[GaryCee]

Hello

Any help is much appreciated! I have a spreadsheet where I log materials invoices and I would like to highlight a cell if it contains the supplier but I have forgotten to enter the invoice amount (and vice versa).

So if I have an invoice for Smiths and I enter the Supplier in A2 but if I forget to input the invoice amount in B2 I would like to highlight B2 as it is empty.

Similarly I would like to highlight A2 if I enter the amount in B2 but A2 is empty as I have forgotten to enter the supplier name.

Thank you!

	A	B
1	Supplier	Amount
2	Smiths
3	Jones	£3.00
4	Bloggs	£4.00

<tbody>
</tbody>

 

[63falcondude]

Highlight A2:B100 (or however far down you want to go) > Conditional Formatting > New Rule > Use a formula

=AND(COUNTIF(A2,""),COUNTIF($A2:$B2,"<>"))

Format: Fill however you'd like > OK

 

[Joe4]

OK. You will have two rules.

First, for column A, highlight cells A2:A4, go to Conditional Formatting, choose the formula option, and use this formula:

=AND($A2="",$B2<>"")

then choose your formatting option and click OK.


First, for column A, highlight cells B2:B4, go to Conditional Formatting, choose the formula option, and use this formula:

=AND($A2=<>,$B2="")

then choose your formatting option and click OK.

 

[Scott Huish]

Select Column A and use this as the Conditional Formatting Formula:
=AND($A1="",$B1<>"")

Select Column B and use this as the Conditional Formatting Formula:
=AND($A1<>"",$B1="")

 

[GaryCee]

This is exactly what I'm after. Thank you so much for everyone's help!

 

[63falcondude]

This is exactly what I'm after. Thank you so much for everyone's help!

You're welcome. Glad to help.