If/Then Conditional Formatting

[pooh53175]

I know I am overthinking this. It is not a difficult task. For the life of me, I cannot figure out a simply Conditional Formatting. I have 2 pieces of criteria:

• If the value in cell D23 is equal to or less than 0 then highlight D9.
• If the value in cell D23 is greater than 0 then highlight D24.

All cells contain a formula. I’ve penciled in the 3 cells it applies to (D9, D23, and D24).

 

[Joe4]

Welcome to the Board!

Select cell D9, and enter this Conditional Formatting Formula:
=D23<=0
and choose your desired formatting color.

Select cells D24 and enter this CF formula:
=D23>0
and choose your desired formatting color.

 

[pooh53175]

Welcome to the Board!

Select cell D9, and enter this Conditional Formatting Formula:
=D23<=0
and choose your desired formatting color.

Select cells D24 and enter this CF formula:
=D23>0
and choose your desired formatting color.

See, I knew it was easy. THANK YOU!

 

[Joe4]

You are welcome.
Glad I was able to help!