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.

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.

Apply Conditional formating to all cell
 

Select the range eg select J14:J626 (with J14 active),
then apply CF using Formula is:
=AND(ISNUMBER($J14),$J14-TODAY()<=60)

The ISNUMBER is an additional check to ensure that blank cells in col J (if
any) do not spuriously trigger the CF. Note that you could actually select
any corresponding range to be conditionally formatted dependent on the dates
in col J, eg you could select say A14:E626 (with A14 active), then apply the
above CF "as-is".
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Kanmi" wrote:
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.

Apply Conditional formating to all cell
 

Wow that is it right there. Thanks alot and appreciate your time. It working
as i want. great job. thanks

"Max" wrote:

Select the range eg select J14:J626 (with J14 active),
then apply CF using Formula is:
=AND(ISNUMBER($J14),$J14-TODAY()<=60)

The ISNUMBER is an additional check to ensure that blank cells in col J (if
any) do not spuriously trigger the CF. Note that you could actually select
any corresponding range to be conditionally formatted dependent on the dates
in col J, eg you could select say A14:E626 (with A14 active), then apply the
above CF "as-is".
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Kanmi" wrote:
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.

Apply Conditional formating to all cell
 

Hi,

remove the $ before the 14. Now copy the cell (which has this conditional
formatting [CF] formula) and select the range over which you want to past
the CF. Now go to Edit Paste Special Formats

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

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