Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting based on cell contents
I want to write a simple macro that I can run on any worksheet that will look
for the value "C" in column "B" and if this value exists change the color of the corresponding cell in column "G" to soft yellow. Each worksheet will have a variable number of rows. I don't want to use conditional formatting and copy/paste because I need to run it every month on a different worksheet, so I want a macro that says for the "active worksheet" the above happens thanks in advance marcia |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting based on cell contents
Columns("B:B").Select
Selection.Find(What:="c", After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Activate ActiveCell.Offset(rowoffset:=0, columnoffset:=5).Activate With Selection.Interior .ColorIndex = 6 .Pattern = xlSolid End With "marcia2026" wrote: I want to write a simple macro that I can run on any worksheet that will look for the value "C" in column "B" and if this value exists change the color of the corresponding cell in column "G" to soft yellow. Each worksheet will have a variable number of rows. I don't want to use conditional formatting and copy/paste because I need to run it every month on a different worksheet, so I want a macro that says for the "active worksheet" the above happens thanks in advance marcia |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting based on cell contents
Hi Sean, It worked great on the 1st one it found, but not any of the ones
after that. "Sean Timmons" wrote: Columns("B:B").Select Selection.Find(What:="c", After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Activate ActiveCell.Offset(rowoffset:=0, columnoffset:=5).Activate With Selection.Interior .ColorIndex = 6 .Pattern = xlSolid End With "marcia2026" wrote: I want to write a simple macro that I can run on any worksheet that will look for the value "C" in column "B" and if this value exists change the color of the corresponding cell in column "G" to soft yellow. Each worksheet will have a variable number of rows. I don't want to use conditional formatting and copy/paste because I need to run it every month on a different worksheet, so I want a macro that says for the "active worksheet" the above happens thanks in advance marcia |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional formatting based on cell contents
Hi,
I'm using Excel 2000, When I ran the code in a private sub in the Sheet1 module, it fails on Selection.Find(What:="c", After:=ActiveCell, LookIn:=xlFormulas, LookAt _ :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _ False, SearchFormat:=False).Activate with a run time error 448, Named argument not found. I'm not sure what I've missed. thanks, Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting based on a cell's contents | Excel Discussion (Misc queries) | |||
Conditional Formatting - For 1 cell based on contents of any cell | Excel Discussion (Misc queries) | |||
Formatting one cell based on the contents of another | Excel Discussion (Misc queries) | |||
Formatting one cell based on the contents of another | Excel Discussion (Misc queries) | |||
Conditional Format based on contents of cell. | Excel Worksheet Functions |