Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I assume to use Worksheet_SelectionChange(ByVal Target As Range)
Whe if I select cell A2 then cell C1 is highlighted. if I select cell A3 then cell E1 is highlighted. if I select cell A4 then cell G1 is highlighted. etc. etc. I think I can carry it on over to column Y if I can see what the first couple of formula or code should be... I figure to use one of these to clear previous fill colors from the range on each selection. Range("C1:Y1").Interior.ColorIndex = xlNone Range(Cells(1, 3), Cells(1, 25)).Interior.ColorIndex = xlNone If it can be done on the sheet conditional formatting function that would be just fine. I could not figure out the formula for a TRUE for the selection cell or column header cell. Thanks, Howard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting with VLookup and Offset functions | Excel Worksheet Functions | |||
ActiveCell.Offset(i, 0) = Chr(ActiveCell.Row + 62) returns all A's | Excel Programming | |||
Offset in Conditional Formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting offset reference | Excel Worksheet Functions | |||
If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) |