Vba to color cells that contains non capitalized letters (help a newbie)

Good Night,

Could someone help me out with a code?

I need to color all cells in 3 columns (E, H, J) that contains at least 1 lowercase letter within, using a RGB color code.

Extra: I'd be even better if at the same time I could change the cell color if the text is fully uppercase (every single letter)

For the entries that contain lowercases I'd use RGB(255, 204, 153), as for the fully uppercase RGB(198, 239, 206)

SOS

Pedro.

It is not necessary to use VBA for this. I would recommend conditional formatting.

Select columns E, H, and J

With the columns still selected create conditional formatting rule

Formula:

Please Login or Register  to view this content.

and apply fill using RGB(255,204,153)

With the columns still selected create another rule:

Formula:

Please Login or Register  to view this content.

Set fill color for cells to RGB(198,239,206)

Sample attached.

Originally Posted by Croweater

If you want VBA though...

Please Login or Register  to view this content.

Worked like a charm!!! Thank you so much

I started trying to create some codes, but I'm still very noob. This will help me a lot with my work and save me lots of time!! s2

Originally Posted by 6StringJazzer

It is not necessary to use VBA for this. I would recommend conditional formatting.

Select columns E, H, and J

With the columns still selected create conditional formatting rule

Formula:

Please Login or Register  to view this content.

and apply fill using RGB(255,204,153)

With the columns still selected create another rule:

Formula:

Please Login or Register  to view this content.

Set fill color for cells to RGB(198,239,206)

Sample attached.

Although its a good idea which I stupidly didn't thought of, VBA would suit me better as I plan to run multiples codes, maybe with button in the close future

Thanks for the reply anyway, this could be useful for me in other stuff!