Change number to be highlight

**hendrikbez** · 07-30-2020, 02:58 AM

i have a excel file and want to know how to do the following with vb Code

On line A2 I have a number 0.00003240 (this number change a few times a day.

On the rest below (I cannot get them to show 0.0000000, they don't want to work, i must make them 0,00000000

Want I need is if the number on A2 is 0.00003240, then all the number just that the same or less must be changed to a color, so if I change A2 to 0.00000123 then all the bottom ones must only show
0.00000123 or less..

Is this possible, if so how do I do it with VB

**:) Sixthsense :)** · 07-30-2020, 03:54 AM

I placed the cursor in B4 cell and extended the selection to cover the rest of the data.

Then opened Conditional Formatting and used the below formula to highlight the less than data.

Formula:

Please Login or Register  to view this content.

Also, attached your file with the above CF for your easy reference.

**hendrikbez** · 07-30-2020, 04:22 AM

Thank you, but when I open your file, I cannot see any one of the columns or rows that are highlighted, and when I change A2 value, the rule disappears

**:) Sixthsense :)** · 07-30-2020, 04:55 AM

Originally Posted by hendrikbez

when I open your file, I cannot see any one of the columns or rows that are highlighted

This is what I see when I open the file which I sent to you.

Screenshot.JPG

**hendrikbez** · 07-30-2020, 05:08 AM

This is what I see when I open it, I am using 2019 pro can that be the problem

I got it to work, thank you

**AliGW** · 07-30-2020, 08:36 AM

Administrative Note:

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

Change number to be highlight

LinkBack

Thread Tools

Rate This Thread

Display

Change number to be highlight

Re: Change number to be highlight

Re: Change number to be highlight

Re: Change number to be highlight

Re: Change number to be highlight

Re: Change number to be highlight

Thread Information

Users Browsing this Thread

Similar Threads

VBA to highlight change in formula in a row

[SOLVED] If number is missing in a sequence, highlight and show number

Highlight change in cells

[SOLVED] VBA Highlight Row On Cell Value Change

Highlight Change in Row

[SOLVED] Highlight entire document and try to change font - won't change.

[SOLVED] change color to highlight changes

Bookmarks

Bookmarks

Posting Permissions