Greetings All,

I have a question regarding utilizing conditional formatting for two
cells within a row. The first cell indicates the ticket age and the
second cell indicates the priority. Currently all priorities have the
same formulas: Condition 1 is Formula Is =$A32 (to produce a red
highlight with white bolded text) and Condition 2 is Formula Is = =
$A3=2 (to produce a yellow highlight with bolded black text).

I need a formula that will read something to the effect of:
Priorities 1 through 4 will maintain the same formulas as above WHEN
the priority cell is equal to priorities 1 through 4. Priority 5 will
have Formula Is =$A32 (to produce a red highlight with white bolded
text) when the priority cell = 5.

Below is an example of how the sheet headings are currently:

Tkt Age Date Assigned User Name Priority
36.00 2007-05-09 TArciszewski 3
32.00 2007-05-10 BKomorowski 5
21.00 2007-04-28 PTadeusz 4


Thanks in advance.

Jason