View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
E.Q.
 
Posts: n/a
Default Mulitple conditional formatting

I don't know of any functions that will help (though I imagine one could be
coded - I've never tried). But in general, if you want only four conditions,
you may be able to use a default as one condition and then use the three
conditional formats for the others.
However if you need multiple formats you may need to use code.

The general format for this code would look like:
PRIVATE SUB WORKSHEET_CHANGE(BYVAL TARGET AS RANGE)
'declarations and initializations here

IF NOT INTERSECT (TARGET, RANGE(rangereference)) IS NOTHING THEN

'code for desired formats here

END IF

END SUB

where what I capitalized is usually in Proper case (initial letter cap) and
represents required code. What I used lower case unique to your application.

Hope that gives you a starting point.
E.Q.



"Conditional Formatting" wrote:

Conditional formatting in excel limits to three. Is there a way can create
more than three condions. please help

thanks in advance