View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dave
 
Posts: n/a
Default Conditional Format based on range

Hi,
Is there a formula I can use in CF to change the format of a cell if the
value is within a specified range? For example, if the value in B1 matches a
value in A1:A20 then I want the format to change.

Thanks in advance.
Dave