Conditional Formatting (I think

[mattyn]

Hi All

I need a really simple way to highlight a cell based on the contents of another - but am getting confused.

In short - I need cell B9 to highlight red when:

• B9 is empty and
• N9 has data.

Also, I would like cell B9 to highlight orange when:

• B9 has data and
• N9 is empty

Both B9 and N9 data will be added manually - so will not be from a formula etc.

Can this be done? If so, how?

All the best, and thank you in advance.

 

[Peter_SSs]

Try like this. I have applied the conditional formatting to B9:B12 so you can see the different effects of data in the two columns in question.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
9														xx
10		xx
11
12		xx												xx
CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B9	1. / Formula is =AND(B9<>"",N9="")	Abc
B9	2. / Formula is =AND(B9="",N9<>"")	Abc

 

[mattyn]

Genius. Thank you.

 

[Peter_SSs]

Thank you.

You're welcome.