Formula to change cell color when stock price is within 10% of 52 week high/low

[ontheroadagain]

In cell F4, I have the current stock price. In cell J4, I have the 52 week high price. In cell L4 I have the 52 week low price. Are there formulas I can use to change the cell color as follows:

1) Change the color of the value in F4:
*if that price is within 10% of the value in cell J4, to BLUE
*if that price is within 10% of the value in cell L4, to RED

OR

2) Change the color of the values in J4 and L4
*if the price in J4 or L4, is within 10% of the value in cell F4 then the color in J4 would change to BLUE for J4 and the color would change to RED for L4

Thank you!

 

[sijpie]

Yes - Use conditional formatting.

Select the cell F4. Go to Conditional Formatting, select New Rule. Click on 'Use a Formula to det...'
Enter this formula
=AND(J4>F4*0.9,J4<F4*1.1)
Do the same again and enter the same formula but change the J4 to L4.

Now use the Format Painter to format the rest of the column in the same way.

Option2 is probably better as you can then see when both are within 10%, but now you can devise the formulas yourself (I hope)