# Show numbers nearly the same

#### hendrikbez

##### Board Regular
Is this possible.

I have a number that can change very time eg 0.00001234
Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004, 0.00000008, 0.00000016 (goes up by double each time.

I need that if the number on top (0.00001234) is about 100 less (0.00001134) or 100 (0.00001334) more, it must show that number in a color

is this possible

#### Peter_SSs

##### MrExcel MVP, Moderator
It was a bit tricky knowing your number format as in post 1 you used "." as your decimal separator and post 3 you used both "." and ",".

With "," separator, my formula would become
=ABS(\$A\$2-A4)<=0,000001

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

#### hendrikbez

##### Board Regular
I am sorry, it is my fault, I did not notice that the rest of them have a , and not a . in them, it should be a . in all of them.
Must get new spectacles, I cannot believe I did not see that it is different.

#### hendrikbez

##### Board Regular
I have done what you said, but it does not show the ones I need to be colored (see screenshot), and when I change the top one, the rule disappeared.
Is there a way to use vb for this.

#### Attachments

• Screenshot_6.png
133.9 KB · Views: 4

#### Fluff

##### MrExcel MVP, Moderator
You are still using a mix of decimal separators, so are your numbers actual numbers, or just text?
If you put
=isnumber(B4)
into an empty cell what does it return?

#### hendrikbez

##### Board Regular

Fluff, I got it to work, thank you for your help

#### Fluff

##### MrExcel MVP, Moderator
Glad you sorted it & thanks for the feedback.

#### Fluff

##### MrExcel MVP, Moderator

@hendrikbez
For future reference while we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

#### hendrikbez

##### Board Regular
O I am sorry about that, will remember that

Replies
8
Views
73
Replies
2
Views
48
Replies
4
Views
53
Replies
1
Views
46
Replies
0
Views
47