Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Apply Conditional Formatting If Data in More Than 1 Cell Matches | Excel Discussion (Misc queries) | |||
Split a cell diagonally and apply a different conditional format. | Excel Worksheet Functions | |||
Apply conditional formatting to individual cell Excel 2007 | Excel Worksheet Functions | |||
Is it possible to apply conditional formating to a pivot chart? | Charts and Charting in Excel | |||
apply conditional formatting to negative cell values | Excel Discussion (Misc queries) |