Multiple Conditional Formatting

Question

Multiple Conditional Formatting

Closed

Report

netty - May 12, 2010 at 01:09 PM
rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

- May 12, 2010 at 01:24 PM

I have workbook that in column 'CD' contains name of various imports, exports. I would like to make all cells that contain the word imports to be a certain color. My formual in excel is =NOT(ISERR(SEARCH("Exports",CD96))), but b/c I have more that three conditional formatting needs I have to put it in vba code.

Multiple Conditional Formatting
Excel vba conditional formatting formula multiple conditions ✓ - Forum - Excel
How to apply same conditional formatting to multiple columns ✓ - Forum - Excel
How to apply same conditional formatting to multiple sheets - How-To - Excel
Excel conditional formatting formula multiple conditions - How-To - Excel
Conditional formatting with multiple rules and blank text cells ✓ - Forum - Excel

1 reply

Ask a question

rizvisa1 · Answer 1 · 2010-05-12T13:24:09-0400

Answer 1 / 1

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

768
May 12, 2010 at 01:24 PM

See this

https://ccm.net/forum/affich-21716-conditional-formatting-more-than-3-in-excel

Multiple Conditional Formatting

1 reply

Your reply

Subscribe To Our Newsletter!