Posted to microsoft.public.excel.programming

external usenet poster

Posts: 788

Including a variable into formatconditions

I am trying to convert the cell reference in the formula1 from a specific
cell to a program selected cell;

B391 to cells(rowindex,columnindex)

(actual code)
Range("B996:Y998").Select
Selection.FormatConditions.Delete
Selection.FormatConditions.Add Type:=xlExpression,
Formula1:="=AND(B391=1)"

everything I try turns into an error

Selection.FormatConditions(1).Interior.Pattern = xlGrid

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Including a third variable in a point diagram by color-coding	Celia	Excel Discussion (Misc queries)	1	January 29th 08 04:47 PM
FormatConditions VBA Bug?	DaveCrowley	Excel Programming	7	May 24th 06 09:52 PM
FormatConditions(1).Formula1	Stefi	Excel Programming	9	February 17th 06 10:37 AM
Including a variable number of columns in Excel Sum formula	Richard Buttrey[_5_]	Excel Programming	1	July 7th 04 10:29 AM
FormatConditions (fails in different Languages)	DamiaoBR[_2_]	Excel Programming	0	May 12th 04 01:54 AM

All times are GMT +1. The time now is 05:51 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us