ExcelBanter - Conditional Formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional Formatting (https://www.excelbanter.com/excel-discussion-misc-queries/241040-conditional-formatting.html)

nbslarson

Conditional Formatting

Is it possible to add conditional formatting for more than 3 conditions?

Sean Timmons

Conditional Formatting

Well, if you have 4 conditions, you can always set one of them as the default
font/background. For more than that, you'd need a macro...

"nbslarson" wrote:

Is it possible to add conditional formatting for more than 3 conditions?

Gord Dibben

Conditional Formatting

Not in Excel versions earlier than 2007.

You would have to use some type of code.........probably event code.

Post an example of what you need.

Gord Dibben MS Excel MVP

On Fri, 28 Aug 2009 11:38:01 -0700, nbslarson
wrote:

Is it possible to add conditional formatting for more than 3 conditions?

All times are GMT +1. The time now is 02:42 PM.