Conditional Formatting?
 

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

Conditional Formatting?
 

=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" wrote in message
...
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

Conditional Formatting?
 

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" wrote:

=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" wrote in message
...
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

Conditional Formatting?
 

Change AND to OR ?
--
David Biddulph

"Ken" wrote in message
...
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" wrote:

=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" wrote in message
...
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

Conditional Formatting?
 

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)



"Bob Phillips" wrote in message
...
=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" wrote in message
...
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

Conditional Formatting?
 

Bob ... (Good morning)

Basically, this is what I did ...

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



"Bob Phillips" wrote:

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)



"Bob Phillips" wrote in message
...
=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" wrote in message
...
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