LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 852
Default Conditional formatting activecell offset

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting with VLookup and Offset functions Phrank Excel Worksheet Functions 2 January 10th 16 09:51 AM
ActiveCell.Offset(i, 0) = Chr(ActiveCell.Row + 62) returns all A's Howard Excel Programming 5 December 25th 12 04:08 AM
Offset in Conditional Formatting? sly411 Excel Discussion (Misc queries) 2 March 22nd 10 08:53 PM
Conditional formatting offset reference IanC[_2_] Excel Worksheet Functions 3 February 17th 10 04:58 PM
If activecell.column = variable then activecell,offset (0,1) Battykoda via OfficeKB.com Excel Discussion (Misc queries) 1 October 2nd 07 08:05 PM


All times are GMT +1. The time now is 03:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"