Highlighting a cell based on 2 different cells values

**athinaida** · 04-27-2018, 09:12 AM

test.JPG

Hello,

I would need your help regarding the following issue (excel file also attached).
I would like to get a formula (if there is) in order to highlight the cells in column B :
- IF the value in B are 0 AND the value in C is not 0 (i.e. green cells in my example)
- IF the value in B are not 0 AND the value in C is 0 (i.e. blue cells in my example)

Thank you so much in advance!

**6StringJazzer** · 04-27-2018, 09:19 AM

There is no file attached. The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

You will use Conditional Formatting, and use a formula. You will need two rules, one for each color. For the first:

Highlight column B and use this formula:
=AND(B1<>"",B1=0,C1<>0)
green fill

Highlight column B and use this formula:
=AND(B1<>0,C1=0)
blue fill

**TMS** · 04-27-2018, 09:20 AM

Select cells B2 downwards and try Conditional Formatting formulae:

Formula:

Please Login or Register  to view this content.

and

Formula:

Please Login or Register  to view this content.

respectively. Choose appropriate colours.

**athinaida** · 05-03-2018, 07:02 AM

Hello,

thank you so much for your quick replies, but unfortunately the formulas haven't worked...
I take back strange results...
Please see my Excel attachment.