- #OPENOFFICE CONDITIONAL FORMATTING MORE THAN 3 HOW TO#
- #OPENOFFICE CONDITIONAL FORMATTING MORE THAN 3 CODE#
Here is what I am doing, I have 1 spreadhsheet with 4 worksheets called Team 1, Team 2, Team 3 & Team 4 the 4th worksheet is the overall or statistics worksheet. I didn't think I explained myself properly. RE: Excel Conditional Formatting with More Than Three Conditions
#OPENOFFICE CONDITIONAL FORMATTING MORE THAN 3 CODE#
Is there any way that these variables can be easily modified by being entered in a separate spreadsheet in the same workbook (call the new sheet 'data'), say, in cells A1:E1, and then the code can be rerun easily without actually having to 'reprogram' the code? Thanks. However, the variables are fixed in the code (I used the numbers 1,2,3,4,5). I have modified it to format a range of cells A1:E500 as shown below such that when the search argument is found, the cell is turned green. RE: Excel Conditional Formatting with More Than Three Conditions acron (MIS) 13 Apr 02 19:44 The only problem is that if I use fill right or fill down, it does not format all of those cells at all (it used to give me an error until I added the "On Error Resume Next" line.) This turns the cells the colors indicated. Private Sub Worksheet_Change(ByVal Target As Range) Here's the code I used, modified from above: This whole list of postings has been REALLY useful for me but I have a question: I have only 5 conditional formats that I need, but they are letters and not numbers, so I cannot use the custom number format suggested by euskadi. Dale Watson Excel Conditional Formatting with More Than Three Conditions DeLaMartre (TechnicalUser) PLEASE do NOT issue a STAR for my posting. But PLEASE, do NOT consider this more than just a "reminder" - i.e. “Acron” has probably “missed out” in the past in getting a STAR for a contribution where the recipient only gave a “thanks” and no STAR. I'm told that other Tek-Tips "browsers" like to use the STARS as a form of "beacon" to guide them to useful threads which probably contain useful tips or solutions to similar problems, or they just want to collect such useful information for a "library".īecause acron’s contribution is a “worthy” one, I’ll go ahead and issue him a STAR, and if you would like to give him a SECOND STAR, that would also be fitting. You only have to click on the "Click here to mark this post as a helpful or expert post! - located in the lower-left-corner of the contributor's posting. The ONLY form of "payment" is the "STARS", so PLEASE show this form of appreciation and recognition. It seems like I'm "one of the few" who bothers to point out to newcomers that the practice of "issuing STARS" here in Tek-Tips is the "proper" method of showing appreciation and recognition for the time contributors take (probably out of a BUSY schedule) to help resolve problems. You can also change the values applied to the color index to suit your own requirements.ĪC RE: Excel Conditional Formatting with More Than Three Conditions DeLaMartre (TechnicalUser) You will need to change the range references (I have used A1:A20 in the example), to suit the range you are working with.
You can then place code above in the resultantt code pane. To that select the sheet in question, right click on the sheet tab and select View Code. That code must be placed in the codemodule od teh actual sheet you are working with. Presumably it is a result of formulas, in which case trapping th esheet calculate event should assist.
#OPENOFFICE CONDITIONAL FORMATTING MORE THAN 3 HOW TO#
How to approachh that best depends on how the values of the range in question are updated.
Conditional Formatting cannot manage more that 3 conditions, so you must resort to VBA.