All or some of the prices need to be highlighted in some form or another.
Highlight a price in a cell that is different from the same item
Hi
Take a list of numbers. How do you decide which number must be used to compare other to?
Essentially, most of the numbers in the list can be said to be different to one of the others.
You must define the exact rules that need to be used to 'highlight' a number.
Hi
Well, thanks for the extensive explanation.
Is there a shortage of words in your neck of the woods? What about the request or you to define the exact rules?
I use range and type in the cell location which requires an incrementor going downwards.
I was thinking a VSTO project where I code the action in VS, but open to anything.
Hi
If you are or intend to use anything other than VB, then I will leave it for someone else as I do not use Office at all. Other contributors here may help.
What is the format of the data you are using? Is it just data typed in and saved from Exel?
7 people are following this question.
