Coinvert from Yellow Range to Green Range

**minhys1** · 11-01-2020, 11:21 PM

All Method (Formula, VBA, ...)

**mohadin** · 11-02-2020, 03:30 AM

Hi
Try

Please Login or Register  to view this content.

**minhys1** · 11-08-2020, 03:27 AM

mohadin. Great.
In another case, if there are more than 2 cells under a text box or there is only 1 number format cell, how to edit the code above?
Thank you

**jindon** · 11-08-2020, 03:34 AM

Simply

Please Login or Register  to view this content.

**minhys1** · 11-08-2020, 05:22 AM

jindon is very nice. Your code solved my other case, thanks

Coinvert from Yellow Range to Green Range

LinkBack

Thread Tools

Rate This Thread

Display

Coinvert from Yellow Range to Green Range

Re: Coinvert from Yellow Range to Green Range

Re: Coinvert from Yellow Range to Green Range

Re: Coinvert from Yellow Range to Green Range

Re: Coinvert from Yellow Range to Green Range

Thread Information

Users Browsing this Thread

Similar Threads

Make Gauge graph like spedometer but Red-Yellow-Green-Yellow-Red

[SOLVED] Return Green, Yellow or Red based on % on a specific cell

Conditional formatting rule- <10% of average = green, 10.1-25% = yellow, >25.1% = red

[SOLVED] Conditional Formatting- date with red, yellow or green

conditional formating dates green, yellow and red

Dashboard budget vs actuals (green, yellow or red)

[SOLVED] Can I sort columns by colors, example - red, green, yellow

Bookmarks

Bookmarks

Posting Permissions