View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Conditional Formatting

hi
try something like this....
data in g7...adjust to suit..
select g7 and in the CF dialog.....
formula is......=IF(LEFT(G7,1)="v",1,0).....,pick your format

regards
FSt1

"John Pivot Table" wrote:

How can I use conditional formatting for a value inside a cell? For example I
have a cell with the value V10 inside and I want to trigger conditional
formatting only with V not by the V10.