Change Row Background Colour When Text Is Entered Into A Cell

I have the following code that converts any data entered into the worksheet to upper case.

Please Login or Register  to view this content.

I am trying to add a piece of code that will also change the background colour of columns A:F if an “x” is entered into any cell in column F. The code must also remove the formatting if the “x” is deleted.

For example, if x is entered into F6, the background colour changes for A6:F6.

I already use conditional formatting in this workbook, so that solution is not really an option.

Thank you.

Please wrap your code in code tags, before the moderators get you...

Forum rules

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # button at the top of the post window. If you are editing an existing post, press Go Advanced to see the # button.

Cheers

Try this

Please Login or Register  to view this content.

Hope this helps

[EDIT]

Do you need the highlighted row in upper case?
If so what do you want it returned to when "X" is deleted?

Happy to have helped.

Could you now take some time to wrap your code, in your original post, in code tags.

Then if you are happy with the solution, mark the thread solved.