View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bdmatlock bdmatlock is offline
external usenet poster
 
Posts: 3
Default 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.