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.

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.

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.

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.

Try this formula...

=OR(A1="V",A1="V.5")

where you would replace the A1 reference with the active cell in the range
you are setting the Conditional Format for.

Rick


"bdmatlock" wrote in message
...
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.

That's it! Thanks so much.

"Rick Rothstein (MVP - VB)" wrote:

Try this formula...

=OR(A1="V",A1="V.5")

where you would replace the A1 reference with the active cell in the range
you are setting the Conditional Format for.

Rick


"bdmatlock" wrote in message
...
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.