LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Apply Conditional Formatting If Data in More Than 1 Cell Matches Maureen Excel Discussion (Misc queries) 5 March 5th 09 03:35 PM
Split a cell diagonally and apply a different conditional format. Champ Excel Worksheet Functions 2 February 5th 09 06:38 PM
Apply conditional formatting to individual cell Excel 2007 James D Excel Worksheet Functions 3 June 3rd 07 09:59 PM
Is it possible to apply conditional formating to a pivot chart? lay Charts and Charting in Excel 8 April 1st 06 11:37 PM
apply conditional formatting to negative cell values dona Excel Discussion (Misc queries) 2 March 10th 06 12:04 PM


All times are GMT +1. The time now is 07:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"