Conditional Formatting Formula

[bdmatlock]

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.

 

[Mike H]

Try this conditional format formula

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

Mike

 

[Rick Rothstein \(MVP - VB\)]

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]

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]

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]

That's it! Thanks so much.

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