I am trying to change the color of a line. if D1 is true then line is red. If E1 is True then line is yellow. Is this done with VBA? or am i making this more difficult than i should?
I am trying to change the color of a line. if D1 is true then line is red. If E1 is True then line is yellow. Is this done with VBA? or am i making this more difficult than i should?
hi jarrettm,
yes it is possible through VBA, can you post a sample sheet so that we can look in to it.
Have you tried Conditional Formatting?
Please attach you sample workbook..
Cheers!
Deep Dave
I will attach in the morning. The file is on the server at work. I do not have access to it at home.
Jarrettm, we doesn't want the exact worksheet,i think you have an idea how the worksheet looks and what are the column and rows present,so prepare a sample worksheet by yourself and post it.
Sample.xlsx this is a quick sample. I tried conditional formatting. i Could only get it to highlight one cell not the line.
Here it is
SampleCF.xlsx
with VBAPlease Login or Register to view this content.
Last edited by humdingaling; 09-09-2014 at 02:12 AM. Reason: added extra code to clear all color and strikethrough first
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
FWIW:
Please Login or Register to view this content.
thank YOu this works great.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks