View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rob Nance Rob Nance is offline
external usenet poster
 
Posts: 4
Default Conditional Formatting Amendment

Hello

I've currently got a condition as: Cell Value = CN, applied to $H:$H (ie a whole col) but I'd like to change that to "If first character of cell = C". Haven't done this for so long that I can't seem to get the formula right. :( Help?