Google Sheets Conditional Formatting

ZeroG · 2 Jul 2022 at 03:26

I'm using Google Sheets for tracking a currency and I thought this would be a simple thing to do but I can't seem to get it right.

In column E I have a formula D2-C2. In column E I have conditional formatting. If the number is positive then colour the cell green, if it's negative colour the cell red. Simple so far. But then I wanted to add into the mix that if the cell D7 for example is empty then the cell E7 should stay white. For the life of me I just can't seem to work out how to apply this 3rd condition. Would it be using conditional formatting, formulas or a mix of both? Example of table below.

ZeroG · 2 Jul 2022 at 08:36

There is an "Is Not Empty" rule but I couldn't seem to get it to work.

ZeroG · 2 Jul 2022 at 08:42

Semple said:
Set up a rule that says if the cell = 0 then paint it white.

I don't think that would work as the Cell won't have 0 in it. For the current day it will be empty.

ZeroG · 2 Jul 2022 at 09:05

I've tried using the ISBLANK function but I don't think I'm using it right. Is there a command for colouring a cell?

=IF D7 ISBLANK() THEN E7(insert colour command here). I know what I'm trying to do in my head but I just can't find the way of doing it heh.

ZeroG · 2 Jul 2022 at 09:13

gpuerrilla said:
Are you using the Format > Conditional Formatting from the menu or trying to hard code it in?

I was using the menu but wondered if there was a way to hardcode it too.