Show numbers nearly the same

hendrikbez

Board Regular
Joined
Dec 13, 2013
Messages
94
Office Version
  1. 2021
Platform
  1. Windows
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
 
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
 
Upvote 0

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
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.
 
Upvote 0
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
    Screenshot_6.png
    133.9 KB · Views: 5
Upvote 0
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?
 
Upvote 0
Glad you sorted it & thanks for the feedback.
 
Upvote 0
@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.

 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,215
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top