Referencing specific character in a cell

[densac]

I was using Conditional Formatting where if A1 = G the cell was colored Green; A1 = Y colored Yellow and A1 = R colored Red. Now they are adding words after the G, Y, R designation. Is there a way to reference the first character in the cell to designate the color???? So if 1st character in A1 = G it will color green and so on. I'm hoping to still use Conditional Formatting since I'm not proficient at VBA and I need the colors to change as soon as enter is hit. I'm still searching but hoping for help.

Thank you for any direction you can give me.

 

[Norie]

You could use the formula option in conditional formatting with something like this.

=LEFT(A1)="G"

 

[Richard Schollar]

Hi

You can use a formula like the following in conditional formatting:

=LEFT(A1,1)="Y"

Hope this helps!

Richard

 

[densac]

Norie and Richard: Thank you VERY much. That worked perfectly. It seems I was making it harder than I should have. I truly appreciate your help!!