Conditional Formatting based on two different cell values

Question

I want to color a specific cell if (for example):

In this scenario I would like to color B1 red. I want the formula to apply to the entirety of the B-column.

possible duplicate of [Google Spreadsheet Conditional Formatting Based on another Cell Value](http://stackoverflow.com/questions/20545961/google-spreadsheet-conditional-formatting-based-on-another-cell-value) — whereisSQL, Aug 23 '15 at 17:05
When I said that I want this to apply to the entirety of the B-column I meant the following: A1 has value B1 has no value > make B1 red A2 has value B2 has no value > make B2 red A3 has value B3 has no value > make B3 red — Sven, Aug 23 '15 at 17:05

score 6 · Answer 1 · edited Apr 17 '18 at 14:33

6

Try clicking Format > Conditional formatting > Custom formula is:

=AND($A1<>"";$B1="")

Apply this to range B:B and select a red colour format

edited Apr 17 '18 at 14:33

Philipp

answered Aug 23 '15 at 20:35

Chris Hick

This didn't work. It says "Invalid Formula" – Sven Aug 23 '15 at 22:25
here is an example sheet (https://goo.gl/HfSDKA) with the formula applied to column B – Chris Hick Aug 23 '15 at 23:45
Also, your locale might not support the comma, try a semi-colon instead. – AdamL Aug 24 '15 at 00:56
That did it. Needed a semi-colon instead. Thanks @AdamL. – Sven Aug 24 '15 at 08:35

1 Answers1