ExcelBanter - View Single Post - Conditional Format

rasinc

Thanks

"T. Valko" wrote:

I can't find anything searching on the MS
website that gives me definitions of the command.

There is a help file at this link:

http://www.microsoft.com/downloads/d...displaylang=EN

--
Biff
Microsoft Excel MVP

"rasinc" wrote in message
...
Hi Ed,

Sorry for taking so long to get back to you. I was sidetracked on other
jobs. I have just gone through several variations of what you put in the
spreadsheet and it works quite well. I liked the idea of redoing the
background pattern as well. This makes the cell without the formula more
evident and clear to the users.

I appreciate the help. I never would have solved this one on my own as I
have never used the Get.Cell(x) functions before. I did find a couple of
references to Get.Cell(42) and Get.Cell(20) as well however, I can't find
anything searching on the MS website that gives me definitions of the
command. Any chance you know where that is? I usually like to read up on
these things so if I need them in the future, I will have an idea of what
to
use.

Thanks again.

"Ed Ferrero" wrote:

Hi rasinc,

Download a sample file from
http://www.edferrero.com/content/ConditionalFormat.xls

to see how to apply GET.CELL to a conditional format.

Ed Ferrero
www.edferrero.com

Thanks but I have no idea what this does. Unfortunately, even though I
tried
it exactly as you did, it exposed the zeros currently in the fields.