Conditional Formatting?

[Ken]

Excel2003 ... To turn pattern of every other row ... I am using conditional
format formula ... =mod(row(),2)=1

to change Font RED for any Cell Value ending in "P/T" ... I am using
conditional format formula ... Right(Cell,3)="P/T".

Above said ... I would like to write conditional format formula that will do
both at the same time ... Alternate Cell Pattern for every other row & Font
Pattern RED for any Cell Value ending in "P/T".

Thanks ... Kha

 

[Bob Phillips]

=AND(MOD(ROW(),2)=1,RIGHT(Cell,3)="P/T")

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Ken]

Bob ... (Hi)

This is one combination I tried, but it only RED Fonts every other Row where
"P/T" might be found.

To clarify ... I need to conditional format pattern every other row ... &
RED Font Cell Values ending in "P/T" which are random (not every other row).

Above said ... I am thinking I need 2 Condition Statements (white pattern,
Red font ... Brown pattern Red Font ... but am stuck on how to write ...

Thank you for supporting these boards ... Kha

 

[David Biddulph]

Change AND to OR ?
--
David Biddulph

Bob ... (Hi)

This is one combination I tried, but it only RED Fonts every other Row
where
"P/T" might be found.

To clarify ... I need to conditional format pattern every other row ... &
RED Font Cell Values ending in "P/T" which are random (not every other
row).

Above said ... I am thinking I need 2 Condition Statements (white pattern,
Red font ... Brown pattern Red Font ... but am stuck on how to write ...

Thank you for supporting these boards ... Kha

 

[Bob Phillips]

Use 3 conditions,

condition 1

=AND(MOD(ROW(),2)=1,RIGHT(Cell,3)="P/T")

with the colour pattern and the red font

condition 2

=AND(MOD(ROW(),2)=0,RIGHT(Cell,3)="P/T")

with the no colour pattern and the red font

condition 31

=MOD(ROW(),2)=1

with the colour pattern


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Ken]

Bob ... (Good morning)

Basically, this is what I did ...

Thank you very much for supporting these boards ... Kha