Need some help with conditional formatting/rules

Cryov

New Member
Joined
Aug 26, 2014
Messages
26
I have two columns with numbers. The first column represents commission, the second column represents hours worked, and each row is an employee.

First column has a conditional format to fill in the cell with red if the number is negative.

Now this is where I need help.

In the second column I want the cell to fill in yellow when two conditions are met.
First: The cell in the first column needs to be red/negative.
Second: The hours worked needs to be less than 40. Preferably greater than 0 as well so all the empty cells don't highlight unless of course you know another way to deal with that.

Any help would be greatly appreciated!

Thanks in advance!
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Cryov

New Member
Joined
Aug 26, 2014
Messages
26

ADVERTISEMENT

Think I said my thanks to early.
AND function only has a TRUE or FALSE output, I can't find a way for it to influence the fill option. I've tried putting it into conditional formatting but nothing happens.
 

bbott

Well-known Member
Joined
Feb 5, 2010
Messages
2,350
Think I said my thanks to early.
AND function only has a TRUE or FALSE output, I can't find a way for it to influence the fill option. I've tried putting it into conditional formatting but nothing happens.

Sorry, I had my signs reversed. Try:

=AND(A1< 0,B1< 40,B1 >0)
 

Watch MrExcel Video

Forum statistics

Threads
1,109,032
Messages
5,526,355
Members
409,697
Latest member
christopherlewis1620

This Week's Hot Topics

Top