The file named Problem30data.xlsx contains statistics for 2014 NFL quarterbacks. In cell J21, I will enter a

Question:

The file named Problem30data.xlsx contains statistics for 2014 NFL quarterbacks. In cell J21, I will enter a number of yards (x). Use conditional formatting to highlight all information for all quarterbacks whose YDs>=x. For example, if we enter 4500 in cell J2, then any QB with YDS>=4500 should have all their information highlighted.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: