Excel Conditional Formating

  • Thread starter Thread starter Alan Porter
  • Start date Start date
A

Alan Porter

Is there anyway to add more than three conditional formats
to an excel spreadsheet.
 
Alan,

It requires a macro to have more than three conditional formats per cell.

This may or may not help. It's possible to use Conditional Formatting in
other cells based on the contents of the original cells. For example cells
in column B could be conditionally formatted based on the contents of column
A. They could be different conditional formats than those of column A.

Regards from Virginia Beach,

EarlK
 
Hi Alan,
The logical next step is to use an Event Macro when the three
Conditions per cell limit is too restrictive.
http://www.mvps.org/dmcritchie/excel/event.htm#case

C.F. picks up changes due to formulas as well as manual changes
but it certainly has it limitation at 3 conditional formats per cell.
http://www.mvps.org/dmcritchie/excel/condfmt.htm

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2010>2003 1
Sorting Cells with Conditional Formats 1
Conditional formatting causing auto complete to deactivate? 3
Conditional Formatting and Formulas 1
Conditional Format - How to View??? 1
Excel 2007 - A Conditional Formatting ?'s 1
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Font changed by Conditional Formatting 1

Back
Top