Setting Range Command

[Frank Stone]

have you tried conditional fomating.
go to Formats>conditional formats.
a dialog box will appear. you can format a cell or range
of cell to many conditions but only for values in the cell.
you can not format based on conditions in another cell.

-----Original Message-----
New to Visual Basic.
Formatting cells in Excel, I need to set background color

for a cell if a condition is met. The required cell is
variable, based on row and colunm number. Range needs an
absolute value. Is there a way of conerting row and column
to value range command needs or is ther a better way?

 

[Guest]

Frank,
Using your process pointed me in right direction. Was able to determine correct
coding needed to complete item. Turned out to be one line of code, not the code I
was trying to use.

Thanks
--
Larry T.

have you tried conditional fomating.
go to Formats>conditional formats.
a dialog box will appear. you can format a cell or range
of cell to many conditions but only for values in the cell.
you can not format based on conditions in another cell.

-----Original Message-----
New to Visual Basic.
Formatting cells in Excel, I need to set background color

for a cell if a condition is met. The required cell is
variable, based on row and colunm number. Range needs an
absolute value. Is there a way of conerting row and column
to value range command needs or is ther a better way?