Change Cell Colours When Inputed In Another

May 29, 2009

was looking if you could change a row of cells background colour if certain word is inputted elsewhere. in b2:f2 is data- was looking if, could these cells background colour change when yes is entered in G2? does not matter which is used, VBA or con formatting just cant work it out.

View 9 Replies


Change Cell Colours Based On Date Range In Two Other Cells

Sep 12, 2012

I'm creating a project calendar in Excel and for each task I have a Start Date (A) and End Date (B) in adjacent cells. To the right are corresponding date cells like a timeline set up with 52 cells representing weeks of the year. I.e Week 1 (C) starts at 02 Jul 12, Week 2 (D) starts at 09 jul 12 etc. up to 24 Jun 14 (BF).

Start Date
End date


When a start date and end date are entered in the respective columns, I need to have the color start on the cell for that range in the timeline and that color should carry out to the end date cell in the timeline. A bit like a Gantt chart but not to that detail.

View 2 Replies View Related

Search Row For Inputed Value, Count Each Non Inputed Value

Feb 13, 2007

This is a lottery challenge that I am facing at work. 6 numbers are chosen from 45 on a weekly basis. Using about 20 years worth of information, I have code that provides a dynamic frequency list in descending order.

I'd like to now have the user pick a number from the above list and see what other numbers have come up with these frequencies. I guess ultimately I'd like 2 or 3 "favorites" with the corresponding frequencies. Trouble is I've been going around in circles with nothing working

View 2 Replies View Related

If Statement In Macro: Macro To Change A Range Of Cells Colours Based On A Single Cell?

Mar 16, 2007

1st - Need a macro to change a range of cells colours based on a single cell having a value greater than 0.001. ie. cells A1 - G1 need to change to grey based on cell F1 having a value greater than 0.001 entered in it?

2nd - Also a macro for deleting the text contents of cell C1 based on cell F1 having a value greater than 0.001. Therefor if cell F1 has a number greater than 0.001 it changes the colour of celss A1 - G1 and also deletes the text in cell C1?

View 2 Replies View Related

Merge And Change Colours Of The Cells By Date?

Jan 27, 2014


Is there any way to Merge the cell and coloured automatically by Date range same like above picture. In the Image:

"MERIAN FROM 1/1/2014 12:01:00 AM TO 1/2/2014 10:15:00 AM" is Merged and Coloured according to Date January 1 and Time 00

Same also...
"SILVER FERN FROM 1/2/2014 1:20:00 PM TO 1/3/2014 11:20:00 AM"

View 1 Replies View Related

Top 3 With Dark Colours - Remaining 2 With Light Colours In Conditional Formatting?

May 6, 2014

I'm sure this will be an easy query.

These are marks scored by 5 people in 10 exams

Name of the student

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

View 1 Replies View Related

If Statement To Highlight Cell Once Data Is Inputed

May 15, 2009

i am going to be making other columns with data. i want it to highlight the cell from the new columns if the value is higher than the standard.

not quite sure how to do this? do i make an if statement and put it in the cell, then go and input my data over it?

View 3 Replies View Related

Offset From Cell Based On Inputed Week Number

May 20, 2008

I want to have a variable range.

ie. This value M4 needs to change based on the week.


If it's week 1, then it can be say M4, but week two will need data to go to N4.

I have found out how to get the week number from the user. ie.

' Select Week Number
Dim NumSheets As Integer
Dim Prompt As String
Dim Caption As String
Dim DefValue As Integer

Prompt = "What week do you want to get data for?"
Caption = "Week Number"
DefValue = 1
NumSheets = Val(InputBox(Prompt, Caption, DefValue))
If NumSheets > 52 Then MsgBox "Week Number too high"
If NumSheets < 1 Then MsgBox "Week Number too low"

I tried then linking this value saved as NumSheets by:

Dim Rng As Range

If NumSheets = 1 Then Rng = Range("D3")
If NumSheets = 2 Then Rng = Range("E3")

View 3 Replies View Related

Getting The False Out Of The Cell And Have A Blank Cell If There Is Nothing Inputed

Jul 28, 2008

=IF(C22="BLUM MOTION",(VLOOKUP(G22,Info!B14:C22,2,FALSE)),IF(C22="ACCURIDE",(VLOOKUP(G22,Info!E13:F31,2,FALSE))))

Can anyone take alook @ the formula above and help me out w. getting the false out of the cell and have a blank cell if there is nothing inputed

View 9 Replies View Related

Metallic Background Colours / Other Colours

Oct 29, 2007

The 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?

View 9 Replies View Related

Manipulation Cell Colours

Jun 22, 2009

Is 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 Related

Use Cell Colours In Graph

Feb 21, 2007

Attached 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 Related

A Cell Colour Based On 5 Other Cell Colours That Have Been Conditionally Formatted

Jun 30, 2009

Using 2007, I need to conditionally format a cell colour based on 5 other cell colours that have been conditionally formatted. The 5 other cells will be coloured either red or greem. What I want to do is have an overall status cell that would be show green if all of the other 5 cells were green, amber if 4 of the other cells were green and one was red and red if 3 or more cells are red.

View 4 Replies View Related

Keep Cell Colours Regardless Of Sort Function

Jan 8, 2010

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.

View 2 Replies View Related

Counting Numbers And Colours Within Cell?

Jan 31, 2013

I wish to count the "number" of numbers in a cell i.e.

Cell A1 has the following data: 12 25 25
This should return 3

Simillarly 4546546545646456 1 2
Should also return 3

I will have data such as the above in a row so i need the count to be able to count a range as opposed to the single cell example above.

Furthermore I need a separate count to count the number or red numbers in a cell. Same parameters as above.

View 4 Replies View Related

Selecting Cell Range Of Colours

Oct 21, 2009

Is it possible to select only cells of a certain colour, then change these cells to a different colour? example

I want to make the dark grey columns a light green and the red columns a lets say yellow and the text black. Is this possible??

View 9 Replies View Related

Follow On From Cell Colours As Criteria

Feb 19, 2007

does anyone know of a way to amend this to add the cell to a range say "All_blue" to then copy and paste special values.

Private Sub Worksheet_SelectionChange(ByVal Target As Range) ...

View 4 Replies View Related

Changing Cell Colours Depending On Cell Content

Nov 19, 2008

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 Related

Distinct Colours In A Cell And Conditional Formatting

Feb 8, 2010

This question about conditional formatting appears to be easy. Lets say I have a column like the following, like I posted somewhere else: (not very relevant for this)


How do I have all characters in this column be coloured accordingly to:


So that 7UUGGRRR would automatically switch to:

What I already tried:

- I applied conditional formatting to the column (actually, the cells interval, [C2..C8]) creating the rule: 'format only cells that contain -> specific text' -> then I added "U" as the text and told it to colour blue. As I predicted, this didn't work; the entire cell containing a single "U" will get blue, which is unwanted.

View 9 Replies View Related

Cell Colours For Negative And Positive Values

Jan 24, 2014

I've got 12 months worth of business accounts which have been downloaded onto a single spreadsheet.

These show negative and positive values. As I only want to work on the negative figs at the moment, how do I highlight the colour of the positive value cells or font to prevent any mistakes ?

View 1 Replies View Related

Copy Cell Interior Colours Between Workbooks

Jan 26, 2008

i am pretty good with VBA after reading a lot of information on the internet but i have a problem i cannot solve:

I have two workbooks with the same sheet names and I am trying to transfer the interior colour of cells from one workbook to the other...

this is the code i came up so far but it doesn't work

With Application.Workbooks(WB1).Worksheets
For Each ws In Application.Workbooks(WB2).Worksheets
On Error Resume Next
For Each cl In ws.UsedRange =
Next cl

Next ws
End With

View 9 Replies View Related

Line Graph Show No Value When No Value Is Inputed

Dec 29, 2008

X-Axis = Week1:Week13
Y-Axis =Revenue for each week.

I have a line graph. If "Week9:Week13" have no value, my graphs line drops to 0. How do I make my line graph show no value when no value is inputed for "Week9:Week13"? I think I need to incorporate the =NA() in the original formula but I'm not sure how to do this.

View 9 Replies View Related

Prompt If Numeric Values Inputed Is Less Than Five Digits

Mar 5, 2009

I have a userform which has a textbox for employee id. If an employee enters less than 5 digits, it should prompt the user via msg box that he needs to enter 5 digits for employee id. However my coding doesnt work...can someone help me correct it?

View 6 Replies View Related

Update A Formula Based On A Newly Inputed Number?

Oct 10, 2008

What i would like to happen is after inputing a number into say column B have that number update a formula in cell D2.... so for example... lets say i have

B1 = 1000
B2 = 2000
B3 = 1400
B4 = ???
D2 = (B3-B2)/B2

is there a way to make it so when i enter a new number in B4 it will automatically update the formula to display the value for (B4-B3)/B3 and then continue on to repeat this process when i enter values into B5, B6, B7 ect?

View 4 Replies View Related

Search Through Rows In Array And Check If There's No "text" In It Like User Inputed In Box

Apr 17, 2009

the task for the code below is to search through rows in array and check if there's no "text" in it like user inputed in box. But it always shows that there's no such email,i can't figure out the mistake, Maybe the problem is in the type the InputBox returns? But i've tried entering type := 2 (text),dunno what else i can do...I've also tried using p = InputBox("Please,eneter email!").

View 2 Replies View Related

Counting Colours

Nov 9, 2006

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.

View 9 Replies View Related

Get A Total But Only Using Colours

Apr 8, 2009

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.

View 9 Replies View Related

Sum Of Cells According To Their Colours!

Jun 27, 2006

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.

View 6 Replies View Related

Values Into Colours (IF Formula)

Oct 7, 2009

I am evaluating a wellness programme at work. One of the things we measure is BMI (Body Mass Index).

What Im 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 im 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?

View 9 Replies View Related

Changing The Colours Of A Userform

Oct 8, 2008

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'

View 3 Replies View Related

Copyrights 2005-15, All rights reserved