Highlight adjacent cells if contain data

[Cruiser69]

Hi all.
Could anyone please help with highlighting adjacent cells if they contain data.
I have tried conditional formatting, but have had no luck.
What I am trying to achieve is if there is data in columns B & C, for the row to turn to yellow.
If only in column B, then turn to blue
If only in column C, turn to orange.

Thanks for looking.

Regards,

Graham

 

[DanteAmor]

Hi @Cruiser69 . Thanks for posting on the forum.

Try this.
Notice how the $ signs are placed in the conditional formatting formulas:

Dante Amor
	A	B	C	D	E	F	G	H
1	A	B	C	D	E	F	G	H
2		1	1
3		2
4			3
5		4	4
6		5
7			6
8	7			8
9
10
Hoja3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:H10	Expression	=AND($B2="",$C2<>"")	text	NO
A2:H10	Expression	=AND($B2<>"",$C2="")	text	NO
A2:H10	Expression	=AND($B2<>"",$C2<>"")	text	NO

--------------
Let me know the result and I'll get back to you as soon as I can.
Sincerely
Dante Amor
--------------

 

[awoohaw]

try:

Book1
	A	B	C
1
2		213	278
3		283
4
5			299
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:C5	Expression	=AND($B2="",$C2<>"")	text	NO
A2:C5	Expression	=AND($B2="",$C2="")	text	NO
A3:C5	Expression	=AND($B3<>"",$C3="")	text	NO
A3:C5	Expression	=(AND($B3<>"",$C3<>""))	text	NO
A2:C5	Expression	=AND($B2<>"",$C2="")	text	NO
A2:C5	Expression	=(AND($B2<>"",$C2<>""))	text	NO

 

[Artik]

Other way.

1. select, for example, the range A2:H20.
2. In conditional formatting, use the following formulas in the order I listed:

=LEN($B2)>0
=LEN($C2)>0
=AND(LEN($B2)>0,LEN($C2)>0)

3. with the last formula entered (in the window it will be the first one), check "Stop if True".
4. done

Artik

 

[Cruiser69]

Hi all.

Thanks for all your replies.
I've tried them all and they all work perfectly.

Regards,

Graham