Hello,
I am hoping one of you Excel Masters can help me with my Conditional Formatting desirers.
What I would like to do is Highlight all the rows between 2 Values.
Currently I am using > Use a formula to determine which cells to format.
The formula I am using is =INDIRECT("R"& ROW())=$U$3 I then have it applying to =$A$7:$Z$1066.
This works great for part of what I would like to do, it takes the weight data I have in cell $U$3 and then highlights the part of whatever row that contains that data I need it to.
What I would like to do differently is use a second data point, the weight data I also have in cell $U$5 and then have it highlight all the rows between those two data points.
Is this something possible, it seems to me like it should be???
Thanks
I am hoping one of you Excel Masters can help me with my Conditional Formatting desirers.
What I would like to do is Highlight all the rows between 2 Values.
Currently I am using > Use a formula to determine which cells to format.
The formula I am using is =INDIRECT("R"& ROW())=$U$3 I then have it applying to =$A$7:$Z$1066.
This works great for part of what I would like to do, it takes the weight data I have in cell $U$3 and then highlights the part of whatever row that contains that data I need it to.
What I would like to do differently is use a second data point, the weight data I also have in cell $U$5 and then have it highlight all the rows between those two data points.
Is this something possible, it seems to me like it should be???
Thanks