View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default Apply Conditional formating to all cell

Select J14:J26 and use

=$J14-TODAY()<=60

--
__________________________________
HTH

Bob

"Kanmi" wrote in message
...
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.