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


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



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

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

How To Change Type Of Border

Apr 24, 2014

How can I modify this code:

HTML Code: 

Sub aaanewa()
Dim lRow As Long, c As Range
lRow = Cells(Rows.Count, "D").End(xlUp).Row
For Each c In Range("D1:D" & lRow)
If c.Value > "" Then


To include this:

HTML Code: 

With Selection.Borders(xlInsideHorizontal)
.LineStyle = xlContinuous
.ThemeColor = 1
.TintAndShade = -0.14996795556505
.Weight = xlThin
End With

so i can change the color and size of border

View 2 Replies View Related

Change Border Widths Via Points

Mar 6, 2007

if it is possible to change the border thickness weight via points? Eg., "1/4 pt".

I find that the xlthin border prints too thick. The only way I've been able to reduce it to appearing thin when it prints is by choosing the second option under "None" in the Line Style option of the Format Cells dialog box.

While that approach prints a thin border, it is actually a dotted line and looks a bit odd on screen.

View 3 Replies View Related

Conditional Formatting To Change Outside Border Of Range Only?

Oct 24, 2013

I'm trying to use conditional formatting to colour the border of a range of cells when another cell has data in it.

I can get it to color all the cells borders within that range when there's data in that cell but I just want the outside of the entire range.

View 4 Replies View Related

Change Line Border Color Of Shape

Sep 21, 2007

I have this simple code which sets the objects format as default.

Private Sub FormatTextBox()
End Sub

Is there a way to set an objects shape to the default format...not as default?

ie: if the default line color is blue. what code could i use to set an object with a black line color, to the default blue?

View 3 Replies View Related

Change Textbox Border Color - Visible Or Hidden

Mar 8, 2012

What command I would use to change the text box border color, and set text border to visible or hidden?

View 3 Replies View Related

Find Specific Phrase In A Column And Change The Row Color And Its Border

Mar 27, 2014

I have the table, as shown on left in the appended image, and the final result should be the right one.

The steps are written as 1, 2, 3 and 4.


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 Columns Fill Or Border Color Based On Current Date

Aug 21, 2014

I have a simple spreadsheet. A column for a persons name and 31 columns, one for each day of the month. I want to apply conditional formatting, either fill color or border color, to the date column of the current date when the spreadsheet is opened.

View 2 Replies View Related

Excel 2010 :: Highlight Active Row - Change Default Border And Fill?

Jan 13, 2013

Using Excel 2010. Is it possible to change the default line thickness and fill color when selecting the ActiveSheet Target Row below?

I would like a thin border and a light grey fill - without interfering with any fomatting or conditional formatting that has been applied to the worksheet.

View 1 Replies View Related

Change The Colour

Nov 29, 2006

condition: the cell in row K and row L can only have value 0 or 1

if cell in the column K & columb L = 1
then both cell is green colour

if cell in the column k column L
then both cell is red colour?

taking example if k1=L1 =1 then is both green colour
if k1 =1 and L1 = 0 then both are red colour

View 9 Replies View Related

Cells Need To Change Colour

Oct 23, 2008

I have developed a profit loss sheet for the office I work for. What i need is to have either cells change colour or the numbers in the cell change colour depening on the value in the cell.

What I was thinking is if the number is over 15% of the sale price the cell or number should be green, if the number is under 15% it should be black, and if its below 0% it will be red.

View 4 Replies View Related

Change Colour To A Whole Line

May 21, 2009

I have this code but is not working, i need to make an ajustment to this as well as at present it will only change colour to 1 cell but i need it to format the whole line, this is what i have so far

View 5 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 The Fill Colour

Nov 28, 2006

I'm looking for some code to change a cell's fill colour

eg. by selecting an individual cell in a range, say A1, the colour of a cell, say K1, in a corresponding range changes to yellow
or if I select multiple cells, say A1:A9, the colour of cells K1:K9 change to yellow

View 9 Replies View Related

Change The Colour Of Shapes

Jul 23, 2007

the VBA to change to colour of a shape based upon the value in a cell?

e.g. if cell "a1" = 10 then colour circle red

View 9 Replies View Related

Change The Font Colour

Oct 1, 2009

I want to change the font colour in row J7:J299 if there is perticular word say "Double" in row J.

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


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


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

View 9 Replies View Related

Colour Change Autoshape

Mar 29, 2007

I have been trying to make it so that an autoshape changes colour according to the value of a particular cell but every time I run the macro the shape is black and I cannot work out why. The code is -

Private Sub CommandButton1_Click()
Dim X As Integer
X = Range("H5").Value
With Sheets("Sheet 1").Shapes("Rectangle 1").Select
Select Case X
Case Is > 0:
Selection.ShapeRange.Fill.ForeColor.RGB = 2
Case Is < 0:
Selection.ShapeRange.Fill.ForeColor.RGB = 3
Case Else:
Selection.ShapeRange.Fill.ForeColor.RGB = 1
End Select
End With
End Sub

View 6 Replies View Related

Colour Palette Change

May 25, 2007

The company I work for has its own set of standard colours to be used in all documents. I've set the colours up in the colour palette using the below sub (x's are actually numbers):

Sub SetCompanyColours()
ActiveWorkbook.Colors(9) = RGB(x, x, x)
ActiveWorkbook.Colors(46) = RGB(x, x, x)
ActiveWorkbook.Colors(12) = RGB(x, x, x)
ActiveWorkbook.Colors(10) = RGB(x, x, x)
ActiveWorkbook.Colors(14) = RGB(x, x, x)
ActiveWorkbook.Colors(5) = RGB(x, x, x)
ActiveWorkbook.Colors(47) = RGB(x, x, x)
ActiveWorkbook.Colors(16) = RGB(x, x, x)
End Sub

I want to distribute this round to my workmates. Problem is that, if they set the colours in the workbook using the above sub, the workbook colours will be all wrong when clients open them on their computer. How do I get around this. I have thought about programmatically copying the sub into the open event of the activeworkbook. I've looked through this website, http://www.cpearson.com/excel/vbe.htm, but it doesn't explain how to copy code to the workbook events part of a vba project, only to a new module

View 3 Replies View Related

Background Colour Change Only Certain Columns In A Row Using VBA

Apr 1, 2013

I want to change the back ground colour of each row until G column when there is a text in the first cell. I have attached the excel that I want the background colour to be. Like suppose, F1 is the details of family 1, F2 is for family 2. I want each family to be coloured. The rows are not fixed for each family. If F1 details are coloured green, Fr is orange, F3 is green and F4 is orange again. And the number F1, F2, F3, F4 and so on are not ordered in ascending. They can be random. But I want the colour coding to be the same as what I have shown in the excel. I have so many rows like that. How do I do that using excel. I have tried conditional formatting. But it doesn't work.

View 2 Replies View Related

Change Text Colour If Value Is Calculated By SUM?

Jun 12, 2014

I need to see easily if my cell is giving a value by using a SUM. This is so I can see if the SUM has been taken off or overridden by typing in a number.

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

Change Font Colour With Different Values

Oct 10, 2008

I'm creating a simple spreadsheet totalling units of alcohol up. Is it possible to change the colour of the fornt when different values are reached? For example if a total of under 8 units is reached this is displayed in green, if over 8 the figure is shown in red.

View 4 Replies View Related

Conditional Formatting: Change Colour

Feb 16, 2010

In cell A1 I have revenue projected & B1 I have actual revenue if the date in B1 is less than the date in A1, I would like B1 to change colour.

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

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