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


ADVERTISEMENT

Xl 07 Can't Change Border Colour

Jan 16, 2009

I am using Excel 2007. One of my worksheets has a dark border around some cells. Instead of being blue the lines are black. I used the right click and format cells option but it does not work.

View 10 Replies View Related

VBA Automatic Default Colour Change To Red Or Green On Existing Workbook?

Mar 7, 2014

I am looking for a vba where by the default colour of the font for new text typed in any cell of a workbook change to green or red and the default black automatic becomes secondary. The existing text in the workbook in its existing font colour must not change i.e stays in black or red.

View 1 Replies View Related

Changing Colour Of The Border Of A Cell

Nov 24, 2008

How can I change its colour? Every time I try to it reverts to the automatic black. I do not want to change the automatic colour (not that I know how to) because black suits me for most of the cells; but there are some where I want a blue border.

This problem arose in conditional formatting but applies to ordinary formatting too. It occurs in 2007 and 2003.

View 2 Replies View Related

Cell Border And Colour With Text

Dec 6, 2008

I have a sheet which automatically adds entrys to the sheet depending on what team they are on, all i really want to do is colour and border to the last row only, i know this should be able to get done in conditional formationing some how but im unsure.

I have got it in some of the cells with text in, but the ones with numbers in remain the same, if i can remember i used con formating and done, if the cell value is greater than <> then my formating, but numbers remain the same.

View 13 Replies View Related

Change The Background Or Highlight (instead Of Bold Border) The Active Cell

Jul 4, 2007

As i navigate excel, I was wondering how to change the background or highlight (instead of bold border) the active cell?

View 3 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

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

Cell Colour Change Only Works Manually

Dec 3, 2011

I have the below code that changes the colour of a cell to green if the figure increases, and to red if it decreases.

The issue is that it works fine if you manually change the figure in A1 or A2 by entering the figure and hitting enter. If the cell figure changes in A1 by any other means such as RTD or say a value in C1 "=C1" then the colour change is not triggered.

Code:
Public oldval, myval

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1:A2")) Is Nothing Then
oldval = myval
If Target.Value > oldval Then
Range("A" & Target.Row).Interior.ColorIndex = 4

[Code] .......

View 9 Replies View Related

Change Cell Background Colour After Subtracting?

Jan 12, 2012

I have a column range,say (a1:a45) that has a 2 digit numerical value, next to that I have a column range, say (b1:b45)

I want to test subtract the value in b1 from the value in a1

if the answer is equal to or greater than 0 I want to colour the cell green.

if the answer is equal -2 I want to colour the cell yellow.

if the answer is less than -2 I want to colour the cell red.

View 9 Replies View Related

Change Colour Of Autoshape Based On Cell Value

Mar 21, 2012

I've seen examples of VBA that will colour autoshapes based on cell values. I have a map of the UK made up of autoshapes that have been edited to create a shape of each postcode area such as EX, GL, NR etc. Also I have a list of all these postcode areas and I have given them a zone number (1-7) depending where in the UK they are.

PcodeZoneDH3DL3DN2DT1DY2E4EC4EH5

At the moment I have set the colours using the fill option so anything that is a particular zone is a certain colour (i.e. zone 2 is green).

What I would like to do is to set a zone to a colour, so the map will update all the zones with the right colours.

I need to be able to read the zone number that is assigned to a postcode area and change the relevant autoshape to the correct colour so that any postcode area can be one of 7 colours.

I can't attach a spreadsheet with my map and postcodes otherwise I would have.

Is there an easy way i can read the zone number of each postcode area in the list and update that autoshapes colour? Would the autshape need to have a name so it know which one to update or is this not possible?

View 9 Replies View Related

Cell Change Colour Large Document?

Sep 14, 2012

Right I want to change a cell interior colour when another cell value is exceeded. I can do this but what I am after because I have over 56 colums and 390 rows I dont want to do this for each one is there a quicker way ? I have this so far which is for one cell only...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
With Selection
If [E8] > [E10] Then
[E8].Interior.ColorIndex = 3
Selection.Interior.Pattern = xlSolid
Else
[E8].Interior.ColorIndex = 0
Selection.Interior.Pattern = xlSolid
End If
End With
End Sub

View 9 Replies View Related







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