VB Code for Conditional Formating

Hello:

Please refer to attached sheet.

I need a VB code(Macro) to perform conditional formatting in column F from cell F3:F40.
If there is space after the text then highlight to yellow.

Example :

Cell F3 has blank space after "01 BRAZIER" so it should be highlighted.

Let me Know if you have any questions.
Thanks.

Maybe:

Please Login or Register  to view this content.

Do you mean you want the macro to apply conditional formatting to column F? Or do you mean you want the macro to do a check and format the cells but not actually apply any conditional formatting to the cells themselves?

For what it's worth, the formula would be something like:
=RIGHT(F1,1)=" "
to return true for your conditional format rule.

Hi HahoBe:

Please find the attached sheet.
According to me, red font fields are the only one with blank character after the text string.
Please re-look and modify the code so that it works.
thanks and Let me Know if you have any questions.
Thanks.

Riz

Hi HahoBe:

I am sorry , i was looking at Johns Code but seems like your code is working.
Thanks a lot and will test further and let you know any issues.
Riz

It's because the code you used in that attachment was to search for a space anywhere in the text. If you use the macro in post#4 or the "normal" conditional formatting formula I provided in post 3 it will be ok