conditional formatting a range of cells based on corresponding values from a different range

[macbiologystudent]

Hi, I have a range of cells that are the results of an analysis and a second range of cells (same dimensions) stating whether or not the corresponding cells are statistically significant. I would like to highlight the cells in the first range based on whether the corresponding cell in the other range is <=.05.

Ex. If results range is A1:J10 and the significance range is A11:J20 (A1&A11 are corresponding cells) could I highlight A1 if A11 is <=.05 and B2 if B12 is <=.05 but not highlight any cells in the A1:J10 range that do not have corresponding cells <=.05?

Conditional formatting will perform this task within a single range but my question is whether I can refer corresponding cells from a second range to the original range I am formatting?

 

[vaskov17]

select cells A1 to J10, make sure to select A1 first and then in the conditional formatting use the following formula:

=A11<=0.05=TRUE

and select the color you need

 

[macbiologystudent]

that worked beautifully, thank you very much