Search : in
By :

Need help with formula for conditional format

Last answer on Apr 28, 2009 6:26:33 pm BST Nohill, on Mar 28, 2009 3:37:02 pm GMT 
 Report this message to moderators

Hello,
if date in cell is less than 2 weeks of the current date highlight it green

Configuration: Windows XP
Mozilla 1.9.0.8

Best answers for « Need help with formula for conditional format » in :
Remove blank cell from conditional formatting Show
Unlimited Conditional Formatting Show Unlimited Conditional Formatting Introduction Principle Code Introduction The limitation of MFC (Conditional Formatting) to Excel version 2007 is less than 3. This is very short. Having seen many applications to push the limit, I am...
Conditional formating - apply on more cells Show
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
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...
[VBA] A function that returns the color of an active MFC Show[VBA] A function that returns the color of an active MFC This function returns the value of the active format in conditional formatting. With the function below, two values can be returned. Mode = 0: the value of Interior.ColorIndex...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
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...
Ask your question Reply

4

excel challenged, on Apr 1, 2009 5:07:04 pm BST
  • +4

Try this in your Conditional formatting formula where I8 in this formula is the cell your formatting and is also where the date being tested is located.

=I8<TODAY()+14

   
Reply to excel challenged

5

 GrayWolf, on Apr 28, 2009 6:26:33 pm BST
  • +4

Not sure if you got this one yet.

Assume the cell you want formatted is A1.
Open the conditional formatting option "format" => "Conditional Formatting"
Condition 1 should look like this:
Cell Value is
Less than
then type the following:
=today()-14

Then just choose the formatting you want the cell to have and voila. Anything with a date older than 2 weeks is hilighted.

   
Reply to GrayWolf
Ask your question Reply
They need your help