Conditional Formatting with more than 3 conditions

[terrapinie]

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

 

[Tom Ogilvy]

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

 

[Frank Kabel]

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

It will just do this

 

[terrapinie]

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

 

[Frank Kabel]

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

 

[richardlamey]

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

Rgds,
Richard Lamey

 

[Tom Ogilvy]

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.