Hi,

The formula I gave you if correctly applied would work if the leftmost cell
was a v or a V irrespective of what else was in the cell.

Select your cell and
Format|Condtitional format|Formula is and paste the formuls in and select a
colour.

Mike

"bdmatlock" wrote:

Thank you, Mike, but that didn't work. The formatting works if the value is
"V", but I need it to also format if the value is "V.5"

"Mike H" wrote:

Try this conditional format formula

=UPPER(LEFT(A1,1)="V")

Mike

"bdmatlock" wrote:

What is the formula to apply conditional formatting if the cell value is "V"
or "V.5"? I can only get it to work with a single value argument.