[excel 2003]

I would like to use conditional formating in a cell such that if the last
character in the cell entry is "X", then the cell background becomes red.

Can anyone help?

Thanks,

Roger

hi
last character in the cell entry = x.......
formula is.......... =RIGHT(B3,1)="x" ........pattern = red

this is cell specific and only works in the cell being entered into. but you
can copy it all over the place, up, down, across etc.

regards
FSt1

"Roger on Excel" wrote:

[excel 2003]

I would like to use conditional formating in a cell such that if the last
character in the cell entry is "X", then the cell background becomes red.

Can anyone help?

Thanks,

Roger

Thanks - this works great

Best regards,

Roger

"FSt1" wrote:

hi
last character in the cell entry = x.......
formula is.......... =RIGHT(B3,1)="x" ........pattern = red

this is cell specific and only works in the cell being entered into. but you
can copy it all over the place, up, down, across etc.

regards
FSt1

"Roger on Excel" wrote:

[excel 2003]

I would like to use conditional formating in a cell such that if the last
character in the cell entry is "X", then the cell background becomes red.

Can anyone help?

Thanks,

Roger