Thread: Conditional Formatting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy Sandy is offline
external usenet poster
  
Posts: 355
Default Conditional Formatting
Mistakenly posted in Functions Repost here

I need a formula for conditional formatting... that will compare the value in
the cell V36 to a list this is what I am trying to use

=VLOOKUP(G36&" "&J36,RATES,3,0)=$K$36

where the concatenation of G36 and J36 is the lookup value


Thanks!
Reply With QuoteReply With Quote