Conditional cell color.

G

geza

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

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


geza said:
I have used conditional formatting before in order to change the shading
Click to expand...
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).
 
J

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
Click to expand...
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).
 
Top