Conditional Formatting Formula
 

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.

Conditional Formatting Formula
 

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.

Conditional Formatting Formula
 

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.

Conditional Formatting Formula
 

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.

Conditional Formatting Formula
 

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.

Conditional Formatting Formula
 

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.