Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Colour row
How do I format an entire row with yellow background if the value in column F
i s larger than 4500? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Colour row
Hi,
Select the row then Format|conditional format Formula us =$F$14500 Select a colour Click OK Mike "Kjellk" wrote: How do I format an entire row with yellow background if the value in column F i s larger than 4500? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Colour row
I may have misunderstood, formuultiple columns select the topmost row (say
row 1) and drag down on the row numbers to select multiple columns then proceed as in my other reply but modify the formula to =$F14500 Mike "Kjellk" wrote: How do I format an entire row with yellow background if the value in column F i s larger than 4500? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Colour row
Hi and thankyou for your fast respons. I was not clear enough when writing my
question. I will try to clarify: When I open the worksheet I want the macro automatically to identify all values in column F which are 4500 and colur those rows with yellow (if the macro not already have done it earlier). Mostly it will be only one row. The conditional format does what I wont but is only colouring the cell with the value. I want it extened to colour the whole row. "Mike H" skrev: I may have misunderstood, formuultiple columns select the topmost row (say row 1) and drag down on the row numbers to select multiple columns then proceed as in my other reply but modify the formula to =$F14500 Mike "Kjellk" wrote: How do I format an entire row with yellow background if the value in column F i s larger than 4500? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Colour row
Please the following in "ThisWorkBook" code sheet
Private Sub Workbook_Open() Dim xR As Long With Sheets("Sheet1") For xR = 1 To .Cells(.Rows.Count, "F").End(xlUp).Row If .Cells(xR, "F") 4500 Then .Rows(xR).EntireRow.Interior.Color = vbYellow End If Next End With End Sub -- Regards, Nigel "Kjellk" wrote in message ... Hi and thankyou for your fast respons. I was not clear enough when writing my question. I will try to clarify: When I open the worksheet I want the macro automatically to identify all values in column F which are 4500 and colur those rows with yellow (if the macro not already have done it earlier). Mostly it will be only one row. The conditional format does what I wont but is only colouring the cell with the value. I want it extened to colour the whole row. "Mike H" skrev: I may have misunderstood, formuultiple columns select the topmost row (say row 1) and drag down on the row numbers to select multiple columns then proceed as in my other reply but modify the formula to =$F14500 Mike "Kjellk" wrote: How do I format an entire row with yellow background if the value in column F i s larger than 4500? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Colour row
Thanks gentlemen .Now you have solved one BIG problem for me.
Regards Kjell "Nigel" skrev: Please the following in "ThisWorkBook" code sheet Private Sub Workbook_Open() Dim xR As Long With Sheets("Sheet1") For xR = 1 To .Cells(.Rows.Count, "F").End(xlUp).Row If .Cells(xR, "F") 4500 Then .Rows(xR).EntireRow.Interior.Color = vbYellow End If Next End With End Sub -- Regards, Nigel "Kjellk" wrote in message ... Hi and thankyou for your fast respons. I was not clear enough when writing my question. I will try to clarify: When I open the worksheet I want the macro automatically to identify all values in column F which are 4500 and colur those rows with yellow (if the macro not already have done it earlier). Mostly it will be only one row. The conditional format does what I wont but is only colouring the cell with the value. I want it extened to colour the whole row. "Mike H" skrev: I may have misunderstood, formuultiple columns select the topmost row (say row 1) and drag down on the row numbers to select multiple columns then proceed as in my other reply but modify the formula to =$F14500 Mike "Kjellk" wrote: How do I format an entire row with yellow background if the value in column F i s larger than 4500? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can colour of cell shading be fixed to one colour | Excel Discussion (Misc queries) | |||
colour rows alternating colour | Excel Discussion (Misc queries) | |||
How do I save new colour schemes for graphs in the colour template | Charts and Charting in Excel | |||
change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
Text in Blue colour, but print in black colour | Excel Worksheet Functions |