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!

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Supplier[/TD]
[TD]Amount[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Smiths [/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Jones[/TD]
[TD]£3.00[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Bloggs[/TD]
[TD]£4.00[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.