Conditional Formatting

[HERMAN]

How do or whats the formula for formating cells based on
the 3rd or 4th character entered into the cell. ie P1R or
P11R the last character is the trigger, thanks

 

[David McRitchie]

Hi Herman,

Would this be what you are looking for.
=RIGHT(A1,1)="R"

Select column A with A1 as the active cell. The formula
is based on the active cell, The colors from C.F. are assigned
based on the Section when creating/modifying C.F.

More on Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

You can always test your C.F. on the worksheet itself
with the same formula.

To match exactly what you said whether that is what you
meant or not.
=RIGHT(MID(A1,3,2),1)="R"
on a worksheet lettercase does not matter r is the same a R

 

[Herman]

Perfecto, thanks muchly

-----Original Message-----
Hi Herman,

Would this be what you are looking for.
=RIGHT(A1,1)="R"

Select column A with A1 as the active cell. The formula
is based on the active cell, The colors from C.F. are assigned
based on the Section when creating/modifying C.F.

More on Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

You can always test your C.F. on the worksheet itself
with the same formula.

To match exactly what you said whether that is what you
meant or not.
=RIGHT(MID(A1,3,2),1)="R"
on a worksheet lettercase does not matter r is the same a R


---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

How do or whats the formula for formating cells based on
the 3rd or 4th character entered into the cell. ie P1R or
P11R the last character is the trigger, thanks

.