I would like to change the colour of a userform both the background colour and the font colour. However, in the colour property box I am met with &H00C0C0C0& (which is Grey). I can select some other colours but not the one I would like to use.
I have tried inserting RGB(194,214,154) however I get the error 'Invaild proprty value'
i am creating a spreadsheet to account for work being done on a team. At the moment the sheet adds up the average time that the whole team is taking to do a task,and it also adds up the time each person is taking.
so for instance: KL take 100 minutes to do the task. but the average time across the team is 90 minutes per task.
i have my list of staff with their times in column E. so what i want is if their time is higher than the average then the box turns red, if it is lower then green etc.
(the average figure is got by summing everyones totals in box B22.
i need a formula that does the following:
if the date is two months under the date it needs to be checked it goes yellow
if its over two months before it needs checked it goes green
if its passed the date it needs to be checked by it turns red
I have a conditional formula which populates a string depending on the value selected by user.
E.G of formula is:- =IF($B$1=0,"CONTACT PERSON - OPTIONAL",IF($B$1=5,"CONTACT PERSON - MANDATORY",""))
Where the result is "CONTACT PERSON - MANDATORY" then I want the word MANDATORY (not the whole string) to be displayed in RED.
I have a conditional formula which gives a value based on what the User specifies.
Example of formula is:
=IF($B$1=0,"CONTACT PERSON - OPTIONAL",IF($B$1=5,"CONTACT PERSON (FINANCE ONLY) - MANDATORY",""))
If the result of the string is " CONTACT PERSON (FINANCE ONLY) - MANDATORY " then
- word MANDATORY (not the whole string) should be in RED
- words (FINANCE ONLY) should be in BLUE
- remaining string should be left in BLANK
Not intending to use VBA. Is this possible?
I have a spreadsheet which reports across different categories, but there's a lot of info. So simplify this, I've written a simple macro that changes the series range in an existing chart, so top level and by category. This works well apart from I'm using excel 2007, and some people aren't, so the default colours look fine on my version, but change to some awful colours on anyone with an earlier version of excel. I need a way of changing the colours to standard ones depending on which macro is being run.
I have tried running the following, but I get an error, basically saying the series hasn't been selected.
ActiveSheet.ChartObjects("Chart 6").Activate
ActiveChart.SeriesCollection(3).Select
ActiveChart.SeriesCollection(3).Interior.Color = RGB(255, 0, 0)
Is it possible to have a listbox with each line with a different colour?
View 2 Replies View Related I'm sure this will be an easy query.
These are marks scored by 5 people in 10 exams
Name of the student
MARKS
MARKS
MARKS
MARKS
MARKS
MARKS
MARKS
MARKS
MARKS
MARKS[code]....
Range
A1 to K6
In each row top 5 MARKS should be filled with BLUE,VIOLET,YELLOW,RED AND PINK
If its not possible. Top 3 with dark colour, remaining 2 with light colour using conditional formatting
What I need to do is have a cell that will be say yellow until there is information put into this cell. The information could be in the format of text or numbers. The information would not always be the same so it would need to be yellow when there is no information in the cell and another colour or white when there is information in the cell.
View 6 Replies View RelatedThe idea came about after wanting to show a 'gold' 'silver' and 'bronze' background colour, but having to plump for yellow, grey and orange looked a little crap :f
If not, can a workaround be created by using code and a picture or 2?
I am trying to query my data, which includes a date field. If the user changes the date, I want to perform certain actions. Once I find the record, I can update all the fields with the userform. However, I can't compare the date in the userform with the date I have found so that it will follow a different course of action. Using the following I get the message whether I change the date or not.
VB:
If VisitorForm.txtLastVisit.Value <> FoundCell.Offset(0, -3).Value Then
MsgBox "Dates Don't Match", vbExclamation, "Sorry"
Exit Sub
End If
If I change the "<>" to "=", the routine stops whether I change the date or not. Something's working, but not right.
I did find that the userform sets the format to mm/dd/yyyy although the data is mm/dd/yy. But I've tried changing the data format and it made no difference.
So im trying to get this userform to work something like this:
User select "Full" or "Half" from OptionButtons.
If "Full" is checked the value of all TextBoxes should be "2" and if checked "Half" it should be "1".
But then they got an option to remove one or two categories. Lets say the user wants to remove category 1 and 2, the value should be double in category 3 and 4, in this case the value should be "4" in both category 3 and 4.
But if the user only wants to remove one category he/she needs to double one of the other three categories.
So what I am looking for is something like the checkboxes are disable or hidden when it should not be an option for them to be used.
The userform that looks like this:
OptionButton1 "Full"
OptionButton2 "Half"
TextBox1 (Category1)
TextBox2 (Category2)
TextBox3 (Category3)
TextBox4 (Category4)
And 8 CheckBox's
The fil: TestForm.xls
I am faced with the task of reducing the size of a group of userforms because of screen size limitations.Some of the forms are quite complex and I am wondering if it is possible to select the form and all its contents and reduce it proportionately. It is possible to do this with the form frame but I have not found a way to include the controls.
View 3 Replies View RelatedIs there any way to change a label in a user form based on the value of a cell?
I'm trying to link a series of labels to a small range of cells that change based on a data-validation drop box.
I've tried finding info, but I can't seem to find the right place.
The code I've tried so far without result is:
Code:
Private Sub Label3_Click()
Me.Label13.Caption = ActiveSheet.Range("BQ15")
End Sub
Is it possible to incorporate actions on one or several userform in to a recorded macro? I would assume to do anything they would have to be modal.
View 6 Replies View RelatedI'm using the following code to create a customized userform, and it works perfectly on my computer, as I've enabled all macro settings.
Code:
Function GetOption(OpArray, Default, Title)
Dim TempForm 'As VBComponent
Dim NewCheckBox As MSForms.CheckBox
Dim NewLabel As MSForms.Label
Dim NewCommandButton1 As MSForms.CommandButton
[Code] .......
However when my coworkers need to use the code it creates an error, as the VBA project is unsafe.
Now my question is, can you write some code that enables all macro settings temporarily, in such a way that my coworkers can use this code?
I would like to know whether it is possible to change the background colour of items in a dropdown/combobox on my userform?
I have a series of times at 15 min intervals and i want, if possible, to distingish between 'working hours' and 'non-working hours' by making the background of these numbers 'grey'.
Maybe looping through from 00:00 to 07:00 i.e 28 times (28 x 15min intervals)?
My Request is in Two Parts.
Firstly, I would like to be able to List ALL the Colours Numbers in One Column & the Corresponding Colours Next to them Please in a Sheet Named "Summary" & Starting in Cell T3.
Secondly, I would like to Count How Many Cells in a Range on a Sheet Named "Network Points" and in Cells F4:Q179 has a Particular Colour Please. I would like the Totals to go on the Sheet Named "Summary" Starting in Cell W3.
Is there anyway to get a total but only using colours?
eg, I want to colour blocks in blue and at the end of the row, I want it to count how many were blue.
I want to know sum of cells according to their colours,but without using "macro".
to clarify my request, take a look in this attached file.
I am evaluating a wellness programme at work. One of the things we measure is BMI (Body Mass Index).
What I’m wanting to do is to categorise the BMI values into “flags”. For example someone who has a BMI of >35 could be red, someone with a BMI of 25-35 could be yellow, and <24 green.
What i’m wondering if excel can do is;
If I write the BMI value one cell can I get excel to automatically fill in another cell in either the colour or the name of the colour?
I have a column where some cells are coloured yellow. In another column, I'd like to mark out these cells, e.g. if the cell next to it was yellow, I would like to to display 'Y'.
View 9 Replies View RelatedIs it possible to create a formula that looks at a cell (say A20) and if TRUE changes the colour of A22 to green if false to red?
View 9 Replies View RelatedI currently have the following macro which checks the cell contents and replaces a random number in a sheet (say Sheet1) with a name in another sheet (called 'Pool') making sure the names' font colour is the same. So for example in sheet1, cell A1 contains the number 1 - the macro looks at cell A1 in the 'Pool' sheet (in which cells A1 to A30 always contain the numbers 1 to 30) and replaces the number 1 in Sheet1 with the name in cell D1 including the same font colour. Basically, it is replacing numbers in one sheet with names on another.
As follows: ...
For a particular requirement I want to utilise the colours.
ANd therefore I need to know, how many colours are present in the Colour Palette in both 2003 and 2007 and which colours would be same if I make the File in 2007?
Are there 60 colours in 2003?
I have so many rows with numbers, when I do the matching I color them with different colors. I am looking for a color code adjacent cell with auto update.
View 9 Replies View RelatedAttached is a table detailing top 20 Incidents and Requests. Requests are highlighted in Yellow and Incidents are in Green. Associated with this table is a graph. What I like to do is if the bar on the graph represents a Request I want the colour to be yellow and if the bar represents an Incident I want it to be green. At the moment I can only choice one colour or a different colour for each bar.
View 4 Replies View RelatedI am in charge of a report spreadsheet which gets updated by my users multiple times a day. The spreadsheet is called the R-A-G report (red, amber, green). One of the columns has colours which are updated manually in accordance to the ammount of stock we have in the database (oracle column) and in our warehouse (utl column).
Right now the users update these colours manually, using a key at the bottom of the spreadsheet. My dream is to have these colours auto-updating when a macro is run.
I spent a little time and wrote a very basic macro, but there are a few problems with it. For one i do not think that the macro fills out of the possible variables; therefor it has around 50% accuracy.
I have uploaded the file and would really appreciate if i could get some feedback on how i could write this correctly, maybe some usefull websites specifically directed at elseif (if that is the correct code for me to use).
In a range, say A1:D5, I need to format cells as follows:
1) If cell contains only "H" or "HV": highlight red
2) If cell contains only a number: highlight blue
3) If cell contains a number with the letter "F" ("1 F" or "5.5 F"): highlight pink
I have a vertical list where every other cell is coloured grey. The values contained in the list are regularly sorted into alphabetical order with new values being added and other being removed.
Is there a way to keep the cells alternate grey & white after I have sorted them? Currently, when I sort, if a cell is coloured grey and is moved down one cell the colour is moved and not just the values.