View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default how can i set more than three conditional formats to xl worksheet

Would 30 be enough?

Bob Phillips' site has a downloadable free add-in called CFPlus which does this.

http://www.xldynamic.com/source/xld.....Download.html


Gord Dibben MS Excel MVP

On Wed, 9 Aug 2006 08:58:03 -0700, Andy A112 <Andy
wrote:

I am trying to set up a sheet showing recurring staff absences. i can only do
Conditional Formats three times on one sheet. With more than three types of
absence I would like to know if ther is a way to increase the number of
Conditional Formats I can make