Thread: Apply Conditional formating to all cell
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default 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 With QuoteReply With Quote