Hi
Just want to know if there is a formula that look at random numbers in column C and gives the high number in D19 and the low number in D20 and the formula in conditional formatting that high light the high number and the low number.
Hi
Just want to know if there is a formula that look at random numbers in column C and gives the high number in D19 and the low number in D20 and the formula in conditional formatting that high light the high number and the low number.
Hi Apiedup and welcome to the forum,
I think you are looking for the Max() and Min() functions like this:
=MAX(C3:C12)
=MIN(C3:C12)
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
As @MarvinP has pointed out the MAX and MIN functions should serve you well here. You could also use the LARGE and SMALL functions if you ever want nth largest/smallest number in a range.
As for conditional formats, they have a built in set for top/bottom. Home | Conditional Formatting | Top/Bottom Rules | Top 10 Items. Adjust the number to 1 if you like for top and set desired format. Same for bottom, but pick Bottom 10 Items and adjust number and format.
Ways to get help: Post clear questions, explain your overall goal, supply as much background as possible, respond to questions asked of you by those trying to help and post sample(s) files.
"I am here to help, not do it for people" -Me
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks