Search : in
By :

Highlight one cell based on date in a range

Last answer on Sep 24, 2009 2:52:11 pm BST coldwind, on Sep 23, 2009 9:50:23 pm BST 
 Report this message to moderators

Hello,
Using conditional formatting I wanted to highlight one cell based on a range. I wanted for example a1 text to be highlighted when one cell or mutiple cells in c1:c10 date was going to expire or about to expire say <=today()+110. I already have the cells in the range c1:c10 to highlight if they are expired. But I am not able to make a1 highlight if c5 has an expired date. It only highlights when its c1.

Configuration: Windows XP Internet Explorer 8.0

Best answers for « Highlight one cell based on date in a range » in :
[Excel] Adding a fixed date in a cell Show[Excel] Adding a fixed date in a cell If you want to insert the current date in a cell in following format DD /MM/YYYY, and that it remains unchanged, without being updated each time the file is opened. Simply type "ctrl" + ";" in the...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
Download Auto Backup for MySQL Professional Edition Show
Download Teleport Pro ShowTeleport Pro is a tool polyvalent to inhale one said of data Internet French. You can, after downloading, make your navigation on PC by being except connection. Teleport Pro can throw up to ten series of requests at the same time on simple sites or...
Download GFI MailArchiver for Exchange ShowGFI MailArchiver for Exchange provides a centralized archive to handle any internal e-mail. It can archive emails in one or multiples databases. Advantage Reduce your message store size and improve Exchange performance Archive past, present and...
Data transmission - The physical connection ShowWhat is a transmission channel? A transmission line is a connection between two machines. The term transmitter generally refers to the machine that sends the data while receiver refers to the one receiving the data. The machines can sometimes be...
Spreadsheets - Conditional expressions ShowWhat is a Conditional Structure? Conditional structures are instructions that allow to test if a condition is true or not. Conditional structures may be associated together. To successfully execute these tests using logical functions, spreadsheets...
Hardware interrupts (IRQ) and conflicts ShowWhat is an interrupt? Since the processor cannot process multiple pieces of data at the same time (it processes one piece of data a time, multitasking is actually the alternation of instruction snippets from several different tasks), a currently...
Ask your question Reply

1

 coldwind, on Sep 24, 2009 2:52:11 pm BST
  • +1

=COUNTIF($C$1:$C$10,"<"&(TODAY()+100)) If anyone had the same problem, I think I figured it out. This has been working when I select cell A1 and put this in the formula the text becomes highlighted when the date is passed and and going to be passed due. Now only if I can figure a macro code that will change the tab color because of an expired date.

   
Reply to coldwind
Ask your question Reply
They need your help