Conditional format to highlight a number that is between to numbers

[still learning]

Hi

How would I write a formula for conditional format that will highlight a number in a range that is between what is in AI and A2.
A1 and A2 have results from formulas
Would it also be possible to have the curser go to that cell that is highlighted

mike

 

[Joe4]

Let's say that you want to apply this to the range B2:D100.
Then select that range, and enter this Conditional Formatting formula:

=AND(B2>=$A$1,B2<$A$2)

and choose your desired highlighting color.

Note that when applying the formula to a multi-cell range, you need to write the formula as it applies to the first cell in that range you have selected.
So if your range starts in say, cell C4, you would change the "B2" in that formula to "C4".

Would it also be possible to have the curser go to that cell that is highlighted

That would require VBA. Conditional Formatting cannot do that.

 

[Fluff]

Where are the numbers you want to highlight?

 

[still learning]

Hi Jo4, Happy New Year
Thank you, That is what I wanted
Hi Fluff, Happy New Year
I thought I would have the sheet open on the result of the conditional format. I don't know how to word the macro to go to the highlighted cell or if its possible because the cell format is changed because of CD

mike

 

[Joe4]

You are welcome.
Glad we were able to help!