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.
|