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
|