Conditional Formatting: Cell Color Changing Depending on Value(s)

[Ottsel]

I need the fill color of cells F150:G150 to remain the color green ■ (Hex: #E2EFDA). If a value in F150 is blank or 0, then I need cell G150 fill color to change to red ■ (Hex: #C00000), but only if the value in F150 is greater than zero.

Example 1​	Example 2​	Example 3​	Example 4​
F150: 1​	F150: 0​	F150: "" (blank)​	F150: 4​
G150: 50​	G150: 50​	G150: 50​	G150: 2​
Result: fill color remains green​	Result: fill color changes to red​	Result: fill color changes to red​	Result: fill color remains green​

The issue I'm facing in the conditional formatting is if the cell is blank or zero, then it changes it to red, but I need my fill color to remain green.

Currently using this: "=F150=0"

Any tips, help or advice would be greatly appreciated!

 

[DanteAmor]

If a value in F150 is blank or 0, then I need cell G150 fill color to change to red ■

I am not understanding.
You want to keep the F150 always green.
If F150 is 0 or white, then only change the color of G150?

 

[Ottsel]

I am not understanding.
You want to keep the F150 always green.
If F150 is 0 or white, then only change the color of G150?

The default color is green in both cells. The color is F150 should never change and remain green.

If G150 contains a number greater than zero and F150 is zero, then the G150 is red
If G150 contains a number greater than zero and F150 is one, then G150 is the default color (green)

Apologies for the poor wording.

 

[DanteAmor]

First highlight cells F150 and G150 in green.
In G150 put the following conditional formatting:

varios 20oct2022 hyperlink hipervinculo.xlsm
	F	G
150
Hoja18

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G150	Expression	=AND($F$150=0,$G$150>0)	text	NO

 

[DanteAmor]

Something like this:

 

[Ottsel]

First highlight cells F150 and G150 in green.
In G150 put the following conditional formatting:

varios 20oct2022 hyperlink hipervinculo.xlsm
	F	G
150
Hoja18

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G150	Expression	=AND($F$150=0,$G$150>0)	text	NO

Perfect! Thank you so much.

Would there be a way to apply this across multiple rows.

For example: F150:F169?

 

[DanteAmor]

Change the formula without the sign in the row

From this:
=AND($F$150=0,$G$150>0)

To this:
=AND($F150=0,$G150>0)