Hi all
Anybody help with this small issue.
Say, I want to enter Variable Data in K1 as "result". Then date verify entry of K1 in L1. When both cells are confirmed, Conditionally Format A1:J1 according to Variable Data in K1.
Hope this explains the problem sufficiently.
Any help welcome
Hi and welcome to the forum
Sorry, actually for me, it doesnt make sense
Perhaps if you uploaded a sample workbook, showing what you are working with, a few sample results and how you arrived at them?
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hello FDibbins
Attached is a sample of what I am trying to do. Hope it makes sense.
Thank you for your reply. Much appreciated.
Any assistance is welcome.
OK yes, that makes sense, thanks
Your profile says 2003, but your file indicates 2007 or later, please update your profile if needed
Assuming 2007 or later...
1. highlight the range you want to apply the conditional formatting to (A2:L5)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =AND($K2="P",$L2>0) format fill the color you have for P
5. repeat 3 & 4 for the other colors
Mr FDibbins
You're a bloody genius. I have racked my head till stupidity, and you seem to have solved the problem so simply.
It worked like a charm on sample sent. Will attempt on main document...which...if you can appreciate is a little more complex.
By using the absolute column reference and changing the result "code" as required...this should work over a much larger "area"???
Hope you are online a little longer, while I go and attempt this on a larger scale.
Again...thank you.
the $ "fixes" the column, the way I used it, sop if you will be using different columns, then you just need to adjust the column reference accordingly. Also, you will probably need to adjust/increase the range you are applying it to.
I should be on for a little longer (its getting late here) but I will be on again tomorrow if I miss you tonite
Mr FDibbins
Code works great for single row...can you shed a little light on how this could be done if I wanted to conditionally format 2 sequential rows...
Cheers bud...thank you...assuming your still on.
Sorry I couldnt stay, pillow was starting to call really loud
can you explain a bit more what you mean by "2 sequential rows"? If you highlight the entire range (A2:L5 in your sample - adjust as needed for the real file), and then apply CF using the rule I gave you (plus the new 1's for each color), it should color all rows that match the rule?
Hello FDibbins
I am including another sample sheet to explain what it needs to do. Seeing how relatively simple you made the last problem look, makes me feel like a bit of a goose in not being able to work it out myself and I probably should have included this in the first instance.
Again any help is very much appreciated.
Thank you
That 2nd files looks to be the same as the 1st file?
Sincerest apologies.
This one should be the right one.
Same file expanded.
Cheers Bud
****
FIUA...This ONE should be the right ONE.
Sorry Bud
I know this is a pain, but off the top of my head, the only way I can think of is to add extra rules for each color. Click on A2, then in the same way you added the other rule/s, add another 1 like this...Your profile says 2003, but your file indicates 2007 or later, please update your profile if needed
=AND($K1="P",$L1>0)
Also, you can highlight the entire range, so that the "applies to" is just this...
=$A$2:$L$8
tip: once you have 1 rule created, you can copy that rule, create new rule and the just paste the ruule and change the "color"
FDibbins
I got it to work. However, in this particular worksheet there are 100 rows, in which case there would be 5 separate conditional formats for each double rows.
I can make it work when I use absolute references in the "applies to" section, but not when I use a relative reference. I don't understand.
Again...any help appreciated
FDibbins
Tried that bud...it didn't work. There must be another way. Beyond me. Can we contact through post e-mail or something?
I can see you are flat out and you obviously operate on no sleep. Champion effort.
Take a look at the attached. I have applied my rules to your file and they seem to work fine.
Keep an eye on the "allows" part, to make sure it if for the entire range
Hi Bud
Something that I have found to be interesting is, that when some cells, or in this case rows are a part of a hide formula it seems to have a weird effect on other lines of code. Would this be true? Found this to be the case in a few scenarios and also when some cells are merged.
Again buddy...I have tried it on my worksheet and it fails to "CF" two rows. Never the less, your formula works great and I will just punch away at it and do them one by one. Thank you...Don't go away. lol
The CF will still apply to the hidden rows, so Im not sure what sort of "weird" effect you would get
OK
Here comes a small portion of the real thing.
Cast you eye across it and see what pops out
Very much appreciated...goes without saying.
I removed all the CF's that you had there, and created 2 new rules...just for NC, once you see how it works, you should be able to create the rest yourself
I'm sorry FD
I must not be explaining myself well. I don't want just those columns CF'd...I wanted the entire 2 rows that those two columns relate to CF'd as in the example sent.
Any possibility of a deeper look?
Cheers bud...Thank you.
OK sorry, I think I wasnt listening lol. just adjust the "applies to" to...
=$G$6:$AV$11
And this is the same range you will use for ALL other rules that will be based on the same criretia
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks