Conditional Formatting
I have a cell that looks like the following: Q4 23 plainfield
what I need to do is have the cell highlight green if the 2 in 23 is a 2. if it is a different number it will have a different color.
I was using the following formula to find the number, but i'm not getting the result i need. =right(left(A2,4),1)
Any help would be much appreciated!
Thank you,
Tyler
Conditional Formatting
No your formula does not work such as in cases like this "Q4 135" or "Q4 6".
The following formula will ALWAYS return the first digit after the space (i.e. 2)
=MID(A2,FIND(CHAR(32),A2)+1,1)
Hope this helps
Conditional Formatting
Figured it out!
=RIGHT(LEFT(AC5,4),1)="2"
I was supper close I just needed to put the last 2 in ""
thank you
Tyler