View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
millee millee is offline
external usenet poster
 
Posts: 3
Default how do i do a highlighted formula?

tks but i figured it out.
=and(t2=""),countif($a$2,v2)=0)


"millee" wrote:

i want a cell to highlight when there is no date in another cell.