conditional formatting

  • Thread starter Thread starter Roger on Excel
  • Start date Start date
R

Roger on Excel

[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
 
Thanks - this works great

Best regards,

Roger

FSt1 said:
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 said:
[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
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
Conditional Formatting with VBA 4
recognizing conditional formatting with VBA 3
Conditional format if difference in cell values greater than 0.50% 1
cell-based conditional formatting on the whole row (Excel 2007) 1
conditional formatting 2
Conditional Formatting macro: simple, but doesn't work 6
Conditional formatting with vba 3

Back
Top