excel conditional formatting default
 

have a need to use multiple conditional formats (three is the max in excel)
but the arguements total five. 1,2,3,4,L. The problem is the conditional
formating is set on 1,2,3; but when 4 & L are used it defaults to condition
2. If it defaulted to condition used for 3 - all would be okay, but why
condition 2? I have removed condition 3 and if I set the arguement to 3 no
conditional formating is applied. If I set the arguement to 4 or L then the
formating for 2 is applied. For 3,4 & L I want the same formating applied.
Any ideas
--
jhkarr

excel conditional formatting default
 

make the third condition "greater than" 2


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=483942

excel conditional formatting default
 

bill,

perfect... thank you. and it handled the alpha too!
--
jhkarr


"bill k" wrote:


make the third condition "greater than" 2


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=483942