Conditional cell color.

[Guest]

I have used conditional formatting before in order to change the shading of a cell based on the cell value. However, I would like to do the same except have the color change based only on the alpha part of an alphanumeric value. Example: change shading to blue if the alpha = F, and change to yellow if = P (as in: F2409 & P1982).

Thank you.

 

[DDM]

Geza, use this formula: =SEARCH("f",A1). If you want it to be
case-sensitive, use =FIND("F",A1). You know how to do the rest...

--
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com

I have used conditional formatting before in order to change the shading

of a cell based on the cell value. However, I would like to do the same
except have the color change based only on the alpha part of an alphanumeric
value. Example: change shading to blue if the alpha = F, and change to
yellow if = P (as in: F2409 & P1982).

 

[JC]

Under conditional formatting use Formula Is and use the
formula: =Left(A1,1)="F" then set the format color.
Create a second condition for P.

JC

-----Original Message-----
I have used conditional formatting before in order to

change the shading of a cell based on the cell value.
However, I would like to do the same except have the
color change based only on the alpha part of an
alphanumeric value. Example: change shading to blue if
the alpha = F, and change to yellow if = P (as in: F2409
& P1982).

 

[Guest]

Thank you very much.