ExcelAlumni
New Member
- Joined
- Jun 19, 2020
- Messages
- 11
- Office Version
- 2016
- Platform
- Windows
Hoping someone can help. Looking for a conditional formatting solution for the following.
Have a long single column of data of differing numbers high & low and want to apply cell color format to highlight only the sequentially lower numbers in order down from the top to bottom.
So for e.g. A1 (1st number) is highlighted, (eg 238,654)
then second lowest down from that, let’s say it happens to be A3 (eg 237,234) (with A2 238655 ignored.)
then 3rd lowest etc…(eg 232,077) & any higher between 237,234 and 232,077 ignored.
In this manner the numbers get lower and lower towards zero with all subsequent higher numbers between each step getting ignored.
e.g. The highlighted numbers would start high and gradually get lower.
I don’t want to simply highlight the 10 lowest numbers in a column. I want to highlight numbers in the column in descending order with each new highlighted number always lower than the last.
- I do not want to use sort data options.
Alternatively an option to copy the numbers descending as described to an adjoining column; if so in same order and row position as original column.
I do not currently have the experience to be comfortable with VBA/Macros
Thanks in advance for any help or suggestions.
Have a long single column of data of differing numbers high & low and want to apply cell color format to highlight only the sequentially lower numbers in order down from the top to bottom.
So for e.g. A1 (1st number) is highlighted, (eg 238,654)
then second lowest down from that, let’s say it happens to be A3 (eg 237,234) (with A2 238655 ignored.)
then 3rd lowest etc…(eg 232,077) & any higher between 237,234 and 232,077 ignored.
In this manner the numbers get lower and lower towards zero with all subsequent higher numbers between each step getting ignored.
e.g. The highlighted numbers would start high and gradually get lower.
I don’t want to simply highlight the 10 lowest numbers in a column. I want to highlight numbers in the column in descending order with each new highlighted number always lower than the last.
- I do not want to use sort data options.
Alternatively an option to copy the numbers descending as described to an adjoining column; if so in same order and row position as original column.
I do not currently have the experience to be comfortable with VBA/Macros
Thanks in advance for any help or suggestions.