If/Then Conditional Formatting

pooh53175

New Member
Joined
Jul 20, 2020
Messages
12
Office Version
  1. 2013
Platform
  1. Windows
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).
 

Attachments

  • PW without Formula.JPG
    PW without Formula.JPG
    36.6 KB · Views: 1

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,470
Office Version
  1. 365
Platform
  1. Windows
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

New Member
Joined
Jul 20, 2020
Messages
12
Office Version
  1. 2013
Platform
  1. Windows
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

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,470
Office Version
  1. 365
Platform
  1. Windows
You are welcome.
Glad I was able to help!
 

Watch MrExcel Video

Forum statistics

Threads
1,118,985
Messages
5,575,381
Members
412,658
Latest member
LS0009
Top