View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kanmi Kanmi is offline
external usenet poster
 
Posts: 76
Default Apply Conditional formating to all cell

Good morning. Please Using following formula in conditional formatting window:-
=IF($J$14-TODAY()<=60,"True","False") and i want to apply to the whole cell.
I mean not only J14 BUT from J14 : J626. Please how can i re-write the
formular. thanks.