Conditional Formatting multiple criteria

[Gman]

Hello -

Anyone know how to highlight a row based on 2 criteria with conditional formatting. See attached for example but I want to highlight the row or the 4 columns based on > or < $2,500 or -2,500 and > or < 5% -5%.

Thank you in advance for your help!

 

[Somendra Misra]

Hi,

Can you list your condition in separate line here like:

1. >2500 And <5%
2. <-2500 And <-5%
....

Regards,

 

[p45cal]

CF formula:
=AND(ABS($C8)>2500,ABS($D8)>5%)
while the active cell is on row 8.

See attached.

A CF using a formula needs that formula to return TRUE for the formatting to be applied. I developed the formula in range G16:G18 and copied the one in G16 in the CF. G16:G18 can be deleted of course.

 

[Gman]

Thank you both. P45cal I especially like the ABS that way I don't have to do both positive and negative!

Nice work, thank you again.