GUIDO22
Registered User.
- Local time
- Today, 08:54
- Joined
- Nov 2, 2003
- Messages
- 515
I am after some VBA code to run or (conditional formatting if that is easier / also possible), where the same three adjacent cells per row are compared to one another.....
Each cell has a numerical value - but I wish to only highlight those rows where the cell values are in Ascending (or Descending) order...
Would appreciate some help from anyone that may know the best way to do this please... thank you.
exmaple:
If the order filter is set DESCENDING
Row #1 = 34 ,65 ,23
Row#2 = 56 , 49 , 45
Row #3 = 32 , 40 , 45
Row#2 is the only qualifier in this case...
Note : I only have use of Office 2007
TIA
Each cell has a numerical value - but I wish to only highlight those rows where the cell values are in Ascending (or Descending) order...
Would appreciate some help from anyone that may know the best way to do this please... thank you.
exmaple:
If the order filter is set DESCENDING
Row #1 = 34 ,65 ,23
Row#2 = 56 , 49 , 45
Row #3 = 32 , 40 , 45
Row#2 is the only qualifier in this case...
Note : I only have use of Office 2007
TIA