View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Doug Doug is offline
external usenet poster
 
Posts: 460
Default Conditional format refers to two cells

How would I tell excel to format a cell based on values in the cell PLUS a
date formula in anouther cell? For example, "if the date in cell P2 is
greater than 365 days AND the cell value in cell Q2 is greater than 9 THEN
color the cell red".

DOUG ECKERT