| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel default date format | Excel Discussion (Misc queries) | |||
| Conditional formatting of a data series in an Excel Chart? | Excel Discussion (Misc queries) | |||
| Excel conditional formatting error | Excel Discussion (Misc queries) | |||
| difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
| Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) | |||
Linear Mode
