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

if I read it correctly
formula is =and($A32,P-cell=5)
make this be condition 1
conditonal formatting uses the first condition which matches

" wrote:

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

On May 15, 4:41 pm, bj wrote:
if I read it correctly
formula is =and($A32,P-cell=5)
make this be condition 1
conditonal formatting uses the first condition which matches



" wrote:
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- Hide quoted text -

- Show quoted text -

BJ,

Thanks so much! That worked perfectly!

Jason