Hello:
Please refer to attached file.
I have data in cell B2:K11
Each cell consist of 12 digits with 1 and 0.
I need to see if digit 1 can have one color font (yellow) and 0 can have other color font (light Orange).
(Either VB Code or Formula would work for me)
Let me Know if you have any questions.
Thanks.
Riz
Hi,
maybe something like this
Please Login or Register to view this content.
If you are pleased with a member's answer then use the Star icon to rate it.
Hello:
I am not sure how to use (Optional rng As Range = Nothing).
Can you please add the code in the attached file and then I will be able to understand and implement according to my need.
Thanks a lot
RM
Hi,
you can use it like this:
RegardingPlease Login or Register to view this content.this makes the argument rng optional, i.e.Please Login or Register to view this content.
is correct statement and rng will be set to ActiveCell within the sub.Please Login or Register to view this content.
Actually, you must also play with rgb values, to find the colors you need, right now they are red and light yellow
Hi Buran:
Superb help.
Thanks a lot!!!
Riz
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks