Conditional Formatting

  • Thread starter Thread starter HERMAN
  • Start date Start date
H

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
 
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
 
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







.
Click to expand...
 
Back
Top