Conditional formatting based on two requirement in different cells

[Mldeuser]

I have a spreadsheet that I am trying to come up with a way to look at variations in two different cells ad if they are met to highlight the cell.

For example I am currently using

=OR(D6>=1000,D6<=-1000) - this is to find any vales greater than or equal to 5,000 or a negative 5,000.

=OR(E6>=10,E6<=-10) this is based on the above.

What I would like is to combine them in column D so if the to statements are found the cell in column D will highlight

For example D9 has a value of (31,038.00) and E9 has a value of (246.47) in this case I would like the conditional formatting to highlight D9

Thank you
Mark

 

[philwojo]

Just combine your two formulas with an AND statement, try this.

=and(or[COLOR=#333333](D6>=1000,D6<=-1000),[/COLOR][COLOR=#333333]OR(E6>=10,E6<=-10))[/COLOR]

Both OR formulas would have be true for you to get a TRUE value for the AND formula.

Also, note, I just copied your formulas from your OP, you stated 5,000, but your formula shows 1,000, just making sure you are aware.

 

[Mldeuser]

This worked gret, thank you for ignoring my typo