I cannot automatic - mark with colour a set dates
Hi
I would like to do automatic marking with colour.
The date are processing from two sets. The difference between sets finds which one cells I should use colour.
And next here is essence of the matter I would like to do automatic marking with colour in the set 2.
I think about a VBA, Macro
Enclosed u will find a example.
Thank u for help
you can use conditional formatting to change cell colors
Im not sure what your criteria is, but lets just say you wanted to color all negative values in rows 20 and 21....
1. highlight the range you want to apply the conditional formatting to
2. on the home tabe, styles, select CF
3. select new rule, select use formula
4. enter =D21<0
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
I want to colour all values in rows 14 and 15. The differences in row 20 21 is only helpful to find it.Originally Posted by FDibbins
When the next year is coming. I am throw away 2010 and replaced a 2011 and replaced a 2011 into 2012 in the both sets. Therefore rows in 20 and 21 are always constant and other sets also.
I will check it, thank u for suggestion.
based on what?? 2011 being < 2010..............2011 being > 2010...what?
if you use the approach I listed above, you can modify and adjust that to suite your needs, just change the ranges and the criteria (<0)
If "difference" counting cell after cell is (-1; -to infinity) or (1; + to infinity) then mark me a cell after cell in "set 2". So if u have got a 0 example in E21 don't mark me E15. If there u had got for example -2 mark me E15.
I don't know how move a mark or not mark to E15.
I can mark if I have got 1 example in F21 but only I can mark in this same cell F21. I cannot to move mark in F15.
ok lets take this step by step...
1. highlight D15:F15
2. on the home tabe, styles, select CF
3. select new rule, select use formula
4. enter =D15>D14 format fill color as required
repeat 3 & 4 with...
=D15<D14
Thank u for idea. I created it, for examples $D$21>0 or $D$21<0 Pls find attached
I had a little problem with this becuase I had worked with Excel 2000.
In Excel 2010 all is ok.
Last edited by jpol; 02-04-2013 at 04:42 AM.
OK, so are you saying you have solved your problem, or that you still need help?
It's ok. I have solved problem. Thank u.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks