CHECKING FOR DESCENDING/ASCENDING RANGE

  • Thread starter Thread starter Jase
  • Start date Start date
J

Jase

I am trying to write a code that will look through a range of cells
range("A1:A15") and checks to see if they are all in ascending/descending
order and if not lets me know by painting the background of those cells or
changing thr font. Is this possible?
 
I would go to Cell A2 and go to Format-->Conditional Formatting. Change the
condition to Less Than and Type =$A1 in the formula window. Click on the
Format Button and Choose Patterns then select a color. Click OK and Click OK
again. Copy the cell A2 and Highlight A3-A15 - Right Click on the Selection
and choose Paste Special and choose Formats then click OK. This should copy
the conditional formatting down. If it is not in ascending order, something
will be highlighted.

HOpe it helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ascending Sort formula, change to neg #: descending sort.. 6
Changing the auto fill order from ascending to descending 9
VBA sort range with certain fontcolor 5
Formula for sorting a range of cells in decending order 6
Acending descending filter screwed my spreadsheet... 2
Sort Ascending/Descending 2
The order of numbers mixed with letters 1
Access errors out when query by ascending 1

Back
Top