View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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.