Conditional Formatting Multiple Values and Multiple Strings.

[iandcph]

Dear Gurus, does conditional formatting work for multiple values or is it strictly for a single value? If possible for multiple, how do I set it to give a cell a blue fill if there is a string of characters (any string, for example, John, Mary, Christian, etc...) and a green fill if it's blank. Thanks in advance. . Cheers!

[iandcph]

edited --
Sample Dashboard with Macros.xlsm

[tdye]

Any one have an answer to this?

I have list of 61 text items in a column on a spread sheet called Data

In another sheet, Week 7, I have set up multiple cells to populate from the list by data validation (all working fine)

These 61 text items will have 1 of 6 colors associated with them selected from the drop down list.

I have successfully setup Conditional Formatting with 6 different, using New Formatting Rules>Classic>Format only cells that contain>Specific text>containing> & this is where my problem is ... I've only been able to put in the text from one cell Not multiple Cells.

So I could make 61 Conditional Formatting Rules for each item in the list but that seems like a lot of work

Am I using the wrong drop down selection in the Conditional Formatting - New Formatting Rule dialog box? Should it be "Use a formula to determine which cells to format" instead?

[FDibbins]

tdye welcome to the forum

I know this was not answered, but Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

[tdye]

Thanks for the heads up!

I posted it here: http://www.excelforum.com/excel-form...t-problem.html

[David A Coop]

Hi iandcph,

It is possible, but you didn't say what you wanted to do!

Where is the condition you want to measure? Is it Col G?

Which cells do you want shaded? The whole row, or just one column (or a few columns).

Note: If you set up Conditional Formatting for blank cells, any shading you have used will be overwritten.

Regards,

DAVID