Using IF and AND function in Conditional formating

picmaster

New Member
Joined
Sep 9, 2014
Messages
11
Hi,

If i want to use conditional formating with these function, is it possible ?

Im try to use if function to create the condition in simple way but I don't understand why symbol < (less) and > (more than) seem unable to work correctly.

I want if Column E is less than 0 (negative) and Column Q is FALSE.

Thankyou in advance,
Picmaster
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Watch MrExcel Video

Forum statistics

Threads
1,108,492
Messages
5,523,260
Members
409,506
Latest member
reneekeane

This Week's Hot Topics

Top