Conditional Formatting Excel 2007

[rtb2399]

Hi,
I am using Excel 2007 and I have to columns G and J that I want to apply the following custom formula conditional formating too, but I have no idea how. If Column G is less than -2%, and Column J is greater then 2% then I want to highlight both of these cells one single color. I have been attempting going to Conditional Formating, and then creating a new formating rule using a formula to determine which cells to format, but I don't have a clue how to set up my formula to highlight both cells. Thank you so much in advance. If you have anyother questions please feel free to reach out to me.

-Tayor

 

[T. Valko]

Hi,
I am using Excel 2007 and I have to columns G and J that I want to apply the following custom formula conditional formating too, but I have no idea how. If Column G is less than -2%, and Column J is greater then 2% then I want to highlight both of these cells one single color. I have been attempting going to Conditional Formating, and then creating a new formating rule using a formula to determine which cells to format, but I don't have a clue how to set up my formula to highlight both cells. Thank you so much in advance. If you have anyother questions please feel free to reach out to me.

-Tayor

Apply the formatting to one column and then do the same thing for the other column.

Use a formula like this:

=AND($G2<-0.02,$J2>0.02)