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

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,431
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,431
Office Version
  1. 365
Platform
  1. Windows
You are welcome.
Glad I was able to help!
 

Watch MrExcel Video

Forum statistics

Threads
1,118,563
Messages
5,572,941
Members
412,490
Latest member
hrzagi
Top