I've seen some of the other solutions for conditional formatting with
more than 3 conditions - and I just cannot seem to get them to work
for me.

I have a spreadsheet that is created by exporting information from an
online database. I want some of the cells to be automatically colored
depending on what is inside them.

For example, in column C is the Status. For cells with the word
'LOST', I want them filled black with white text. For cells with the
word 'CONTRACT', I want them filled blue with white text. Cells that
say 'PROPOSAL', I want them green with white text. And those with the
word 'INACTIVE' or 'ABANDONED', I want them brown with white text.
And these colors only need to be in this column of cells (not spread
across the row).

In column B is the Type. For cells with the word 'RECOMPETE', I want
the text to be blue. This needs to be for that particular cell in
column B and it's preceding cell in column A.

In column L, the rows are assigned with a numerical value, 0 through
4. I want the cell to be filled with a different color depending on
which number is assigned.

There has to be a method to do this (I hope). Can anyone shed some
light??

Thanks so much,
Laurie

Hi
if you don't mind using a beta release addin try:
http://www.xldynamic.com/source/xld.....Download.html

It will just do this

--
Regards
Frank Kabel
Frankfurt, Germany

"terrapinie" schrieb im Newsbeitrag
om...
I've seen some of the other solutions for conditional formatting with
more than 3 conditions - and I just cannot seem to get them to work
for me.

I have a spreadsheet that is created by exporting information from an
online database. I want some of the cells to be automatically
colored
depending on what is inside them.

For example, in column C is the Status. For cells with the word
'LOST', I want them filled black with white text. For cells with the
word 'CONTRACT', I want them filled blue with white text. Cells that
say 'PROPOSAL', I want them green with white text. And those with
the
word 'INACTIVE' or 'ABANDONED', I want them brown with white text.
And these colors only need to be in this column of cells (not spread
across the row).

In column B is the Type. For cells with the word 'RECOMPETE', I want
the text to be blue. This needs to be for that particular cell in
column B and it's preceding cell in column A.

In column L, the rows are assigned with a numerical value, 0 through
4. I want the cell to be filled with a different color depending on
which number is assigned.

There has to be a method to do this (I hope). Can anyone shed some
light??

Thanks so much,
Laurie

If I use this and set up the formatting with it, when I send this file
to others, or upload it to a SharePoint site for others to download,
with the formatting keep? Or will everyone who wants to view the file
with the specified formatting have to also download this beta version
of formatting?

Thanks,
Laurie

Hi
yes they also need this addin as otherwise the formats won't change
anymore if the data is changed. The last format though will remain

--
Regards
Frank Kabel
Frankfurt, Germany

"terrapinie" schrieb im Newsbeitrag
om...
If I use this and set up the formatting with it, when I send this
file
to others, or upload it to a SharePoint site for others to download,
with the formatting keep? Or will everyone who wants to view the
file
with the specified formatting have to also download this beta version
of formatting?

Thanks,
Laurie

just write a macro that loops through your cells and examines each for the
conditions you have described. When the condition is met, format the cell
appropriately.

You can run the macro and process all appropriate cells, or you can use an
appropriate event to trigger the action when a cell changes or a calculation
occurs as an example.

See Chip Pearson's site on events for general information:

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"terrapinie" wrote in message
om...
I've seen some of the other solutions for conditional formatting with
more than 3 conditions - and I just cannot seem to get them to work
for me.

I have a spreadsheet that is created by exporting information from an
online database. I want some of the cells to be automatically colored
depending on what is inside them.

For example, in column C is the Status. For cells with the word
'LOST', I want them filled black with white text. For cells with the
word 'CONTRACT', I want them filled blue with white text. Cells that
say 'PROPOSAL', I want them green with white text. And those with the
word 'INACTIVE' or 'ABANDONED', I want them brown with white text.
And these colors only need to be in this column of cells (not spread
across the row).

In column B is the Type. For cells with the word 'RECOMPETE', I want
the text to be blue. This needs to be for that particular cell in
column B and it's preceding cell in column A.

In column L, the rows are assigned with a numerical value, 0 through
4. I want the cell to be filled with a different color depending on
which number is assigned.

There has to be a method to do this (I hope). Can anyone shed some
light??

Thanks so much,
Laurie

Try: Excel Hacks, by Hawley & Hawley, published by O'Reilly, page 206

Rgds,
Richard Lamey

Question was asked and answered on Nov 10/11 2004.

No need to buy a book for simple problems like that; just search the
newsgroup archives.

--
Regards,
Tom Ogilvy

wrote in message
...
Try: Excel Hacks, by Hawley & Hawley, published by O'Reilly, page 206

Rgds,
Richard Lamey