View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Caroline Caroline is offline
external usenet poster
 
Posts: 183
Default Conditional formatting/non blank cells

Hello,
(Excel 2007) I am trying to format a cell based on another cell being "non
blank". I thought the non blank formula was "<" but it's not working, e.g.
=$E$2="<"
This =$E$2="" works for blank cells but I need it to be "non blank".
Thank you for your help,
Caroline