Hello,
I want to color format a cell based on a percentage value in another cell but I just can't get my head around how to solve it. I've attached a file that explains it better.
E.g.
The formatting for A1 should be something like:
If A2 is
> +/- 10% RED
+/- 6-10% YELLOW
+/- 5% GREEN
Any ideas on how to solve this?
Attachment 214464
Hi D-smoke,
You wish to compare column C with the figure in H5 .. correct ?
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Why do you post again the same question. You have already a suggestion in your other thread without to reply to that..
http://www.excelforum.com/excel-gene...ther-cell.html
So this is a duplicated thread.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hi,
There has been some database issues I think, so it looks like my post has been posted twice. I will disregard this one and focus on the other one. Thanks Fotis1991!
Yes, correct. The A1 and A2 was just examples.
Thanks!
I am not sure if this is the 'thread' to consider as final one ...
Regards,
DILIPandey
<click on below * if this helps>
Thanks Fotis.
Thread duplicate. Closed.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks