Change Cell Colour When Select Cell

Oct 26, 2009

I have VBA code that changes the cell background colour in column A based on criteria in column B. What i want to do is select a cell in the same row in a range column O:AB and change the background colour to the same as column A. This action is for rows 4 to 41.

Basically i just want to click in a cell and for that cell's background colour to change and match the colour in column A.

View 9 Replies


ADVERTISEMENT

Excel 2007 :: Get Cell To Refer To Date That It Contains And Change Cell Colour Based On That?

Dec 19, 2012

I work for a UK charity and have a list of funders in an Excel 2007 spreadsheet.

One of the columns refers to the date on which a new application for funding can be made to that particular funder.

In many cases new applications for funding can't be made for 1 or more years since the last application - sometimes as many as 5 years later. How to get a cell to refer to the date that it contains.

For example, say I have in cell A1 "The Acme Funding Organisation" and in cell B1 (i.e. the "Reapply when?" column) a date of 01/04/2013 (British date format, i.e. 1 April 2013) then what I want Excel to do is to look at the date in cell B1 and if that date has been reached to highlight the cell red. That way I'll know that the reapply date has been reached & that a new application can be made.

View 2 Replies View Related

Excel 2010 :: Change Colour Of Cell Based On Date In Other Cell?

Jan 10, 2013

I am trying to create a sheet in XL 2010.

In Column A each cell will contain a date (differnet from other cells in that column) when inspection was last done.

Column B is when the weekly inspection is due.
Column C is when bi-weekly inspection is due.
Column D is when monthly inspection is due.
Column E is when 6 monthly inspection is due.

I need a formula to change the colour of cells B, C, D & E when each inspection is due depending on the date entered in A

I am hoping its possible that the cell colour can stay for 2 days after the due date and then return back to blank after the second day.

For example if cell A1 has a date of January 1 2013 then on January 8 2013 cell B1 turns red then on January 10 2013 the cell returns back to normal.

A1
B1
C1
D1
E1

Inspection Date
Weeekly Due
Bi-WeeklyDue
Monthly Due
6 Monthly Due

January 1 2013
Change red Jan 8 & return blank Jan 10
Change red Jan 15 & return blank Jan 17
Change red Feb 1 & return blank Feb 3
Change red June 1 & return blank June 3

Ive also attached the worksheet

View 1 Replies View Related

Excel 2010 :: Change Cell Colour Depending On Date In Another Cell

Jan 9, 2013

I am trying to create a sheet in XL 2010.

In Column A each cell will contain a date (differnet from other cells in that column) when inspection was last done.

Column B is when the weekly inspection is due.

Column C is when bi-weekly inspection is due.

Column D is when monthly inspection is due.

Column E is when 6 monthly inspection is due.

I need a formula to change the colour of cells B, C, D & E when each inspection is due depending on the date entered in A

I am hoping its possible that the cell colour can stay for 2 days after the due date and then return back to blank after the second day.

For example if cell A1 has a date of January 1 2013 then on January 8 2013 cell B1 turns red then on January 10 2013 the cell returns back to normal.

A1
B1
C1
D1
E1

Inspection Date
Weeekly Due
Bi-WeeklyDue
Monthly Due
6 Monthly Due

January 1 2013
Change red Jan 8 & return blank Jan 10
Change red Jan 15 & return blank Jan 17
Change red Feb 1 & return blank Feb 3
Change red June 1 & return blank June 3

View 3 Replies View Related

Formula To Change Cell Colour :: Shade A Cell Depending On Condition

Feb 9, 2007

Is it possible to use a formula to shade a cell dependent on a condition? I have tried an if formula (see below) but it is incorrect. =if('November 2006 SVOC'!B6>'March 2006 SVOC'!C6,'November 2006 SVOC'!B6 [red],if('November 2006 SVOC'!B6<'March 2006 SVOC'!C6,'November 2006 SVOC'!B6 [blue],))

View 3 Replies View Related

Select A Cell By Colour

Jan 31, 2009

I want to select the only cell in Column A (there will only be 1) that has the colour index 15. I don't want to do anything with it other than select it. I've searched this, and many other sites, and everyone wants to changes colours or use CF, I just want to select it using VBA so I can use it in a macro.

View 9 Replies View Related

Change Colour And Values Of Cell Based On The Value In Adjacent Cell?

Nov 10, 2012

I need to write a condition in such a way that cell IF A1= "DBR","BPR","SLR","SKR" then change cell B1 to SPECIFIC COLOUR Each condition different colour. A1 values ("DBR","BPR","SLR","SKR") is a list of selectable values. if the condition is falls then B1 should be normal (white color cell) with 0 in it.

View 1 Replies View Related

Formula To Change Cell Colour :: By Value Of Cell In Another Sheet

Sep 30, 2008

I need to set a cell colour by the value of a cell in another sheet so i can't use conditional format. Is there a formula that allows the user to set a cell style, colour, font etc.

View 9 Replies View Related

Cell Colour Change From Result In Adjacent Cell

Jun 1, 2006

I am trying to make the colour of cell change depending on the result in an adjacent cell and have found and adapted the following:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim icolor As Integer
If Not Intersect(Target, Range("x4:x202")) Is Nothing Then
Select Case Target
Case 11
icolor = 43
Case 21
icolor = 43
Case 31
icolor = 27
Case 41
icolor = 27................

View 4 Replies View Related

Change Row Colour When A Value Is Given In A Cell

Aug 7, 2006

I dont have that great knowledge in Excel but i wanted to try and run a
macro in an IF formula but realised that was not possible. I have now got a
formula that gives a value in a cell when i want the whole row to turn to
red, but im not sure how i can get a macro that will change the whole row to
red when that cell shows a value. Can anyone help on this matter?

View 9 Replies View Related

Change The Colour Of Cell

Nov 15, 2006

I am tyring to do conditional formatting whereby if anything is entered in a cell i want the colour to change to say yellow and if nothing is entered just to leave blank.

View 9 Replies View Related

Change A Colour Of A Cell

Nov 8, 2009

How can you change the colour of a cell (A1) using that number

eg

1=red2=orange3=white4=light blue5=Blue12345


OR

Make the cell with numbers above 0 go red and all cells with numbers below 0 go blue

View 9 Replies View Related

Row Change The Colour If A Particular Cell In That Row Contains One Particular Word

Feb 8, 2008

If A1 contains 'good' then row A = red

I need an entire row to change colour if a particular cell in that row contains one particular word.

View 11 Replies View Related

Cell Change Colour Due To What Input

Mar 31, 2013

I am making a little Formula 1 Grand Prix spreadsheet, and would like to know how do i enter a number into a cell and the cell changes colour.

[Code] .....

So if i type when of these in a cell i want to to change to the colour corresponding to the chart.

View 2 Replies View Related

Change Cell Colour On Doubleclick

Jul 17, 2009

I have the code below which fills a cell when doubleclicked. I would like to modify this to altenate between 3 different colours on each doubleclick.

View 2 Replies View Related

How To Change Background Colour Of Cell

Mar 10, 2013

How I can change the background colour of cell C:2 depending on what other cell i click? Below a sample of the code im using Basically when i click B:2 i want C:2 to turn grey with the text on top.... Then when i click B:4 i want C:2 to turn Red.....

Code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Select Case Target.Address
Case Is = "$B$2"
Range("D2").Value = "No action needed connector is down" 'change this to suit
Case Is = "$B$3"

[Code].....

View 6 Replies View Related

Change Cell Colour On Delete

Jan 22, 2007

I would like to have the colour of a cell change within a spreadsheet anytime that a change has been made. I have used the worksheet_change function to change any text that has changed in a cell, however I would like to have the actual cell colour change if someone deletes anything from that cell. I figured that I could use the worksheet_change function for that as well however it is not working.

View 9 Replies View Related

I Want A Certain Object To Change Colour When A Certain Cell = Something

Apr 17, 2007

I dont understand how this event works.

I want a certain object to change colour when a certain cell = something.

View 9 Replies View Related

Change The BG Colour Of A Cell When Selected

Nov 3, 2008

I have 5 cells in the same row (C20:G20)
When i click on one of them i want it to either change the background of the selected cell or the background of the cell below it.

EG if i click on C20 either C20 or D20 the highlight black and change the text colour to white, or just change the background to grey.

i thought it might be something like Target.Offset(1, 0).BGColor = 6

i tried this>

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells = C20 Then
Target.Offset(1, 0).BGColor = 6
End If
End Sub

View 9 Replies View Related

2007 Cell Colour Change

Mar 4, 2010

Trying to have this embedded in the worksheet private sub change section. I want it to change the value of these ranges when the target has a value in it. I'm getting an error though:

If Target.Address = "$E$27" Then
If Target.Value "" Then
Range("I25:J26,P25:P26,R25:S26").Interior.ColorIndex = White
Else
Range("H25:V31").Interior.ColorIndex = 15
End If
End If

View 9 Replies View Related

Change Cell Colour When Clicked

May 26, 2006

I've found a great thread that answered part of my problem (Change colour of text on update of cell)

This code changes the colour of a cell when selected. With the application I'm trying to make I need this effect to only occur in a certain area say A10:D30

I'm trying to make a scheduling page that uses timebars to represent when people are working. I though if a user could click or highlight the hours and a time bar produced I could lookup to see what hour the timebar starts and ends and show the hours worked. I also need it to cycle through 5 different colours before returning to white.

Private Sub worksheet_change(ByVal target As Range)

target.Interior.ColorIndex = 4

End Sub

View 9 Replies View Related

Change Existing Cell Border Colour?

Jul 11, 2012

Is there any way to change the border color of a cell by running a subroutine? Here is my example:

Col 1
Col 2

1
2

3
4

I have an existing table with data that is updated daily ... more rows are added. Currently, the cell border is black. I would like to run a macro such that the column header is shaded grey and the borders turn into a shade of gray. I am interested in the 35% grey.

View 4 Replies View Related

IF Statement To Change Colour Of Text In Cell?

Oct 28, 2012

I have 2 columns of figures. One column has a defined name of 'Estimated Value' and the other column 'Actual Value'

My IF statement should simply read "=If(Estimate>Actual,Text color RED, Text Color Black)

My attempts at finding the code for the True/False statements are legion and 'Conditional Formatting' does not appear to work

View 4 Replies View Related

Change Colour Of Cell Based On Text In Another?

Feb 1, 2013

I am trying to make a cell change colour based on the partial content of another cell.

For example, cell A4 has a alpha-numeric sequence in it and I want cell B4 to turn blue if part of the sequence is ABD or F&C.

View 1 Replies View Related

Change Row Colour If Any Data Populated In Particular Cell?

Jun 26, 2013

I am looking to change a row colour if any type of data is entered into a specific cell.

Context: In column H entitled 'Start Date' when someone enters a date n any format into this box, I want the whole row to change colour to easily see what projects have started and what ones havent.

View 1 Replies View Related

Change Colour In A Cell - Conditional Formatting

Dec 4, 2008

I want to change the colour in a cell depending on the sum of two other cells.
ie
A3=1,B3=1
A4=2,B4=1
A5=1,B5=0
A6=2,B6=4

So i want if
A3+B3>2 THEN C3 TO HAVE GREEN COLOUR
A4+B4>2 THEN C4 TO HAVE GREEN COLOUR
A5+B5>2 THEN C5 TO HAVE GREEN COLOUR
A6+B6>2 THEN C6 TO HAVE GREEN COLOUR

SO IN THE END ONLY C4 AND C6 WILL HAVE GREEN COLOUR.

Is there any formula to do so with conditional formatting?

View 9 Replies View Related

How To Change Cell Colour After A Year Has Passed

Feb 9, 2009

I am trying to devise a service schedule that has the installation date in say cell D4 and I would like this to automatically place a date a year from there in to cell E4, then 4 weeks before date comes round i would like the text cell to turn yellow, then on & after the date to turn red. Is this even possible?

View 12 Replies View Related

Change Cell Colour When The Protection Is Locked

Dec 3, 2009

Is there any way to change the pattern color of a cell (or a group of non-adjacent cells), say from No Color into Red if the cell(s) protection is locked (or unlocked)? Seems to me that the Conditional Formatting cannot work this way.

View 3 Replies View Related

Can Change Colour In A Cell Depending On Result

Jun 3, 2013

Is there any way to have a cell change its colour depending on whether a condition is met. E.G., can i have it as green if the result is a plus number and red if its a negative?

View 2 Replies View Related

How To Change A Cell Colour Depending An A Different Cells Value

Oct 22, 2009

How to a change a cell colour to say red in B6 if cell b12 = 1 and if e6 = 1 to change to green. I thought I might be able to use conditional formatiing but no. I had set the spread sheet to do a cell just for a condition representing a sum from another worksheet and it was working fine but i have to incorporate the two together and am stock.

I have attached a spread sheet.

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved