Search : in
By :

Conditional Formatting Highlighting Row

Pushpa, on Jun 1, 2009 9:47:59 am BST 
 Report this message to moderators

Hello,
I have a column "Expiration Date" in Access report. I want to highlight the entire row whose (expiration date-today's date) is less than 15 days. I want to do this via conditional formatting only (if possible).I tried DateAdd("d",15,Date()) , but it is just highlighting the single column for which i am putting the condition.Kindly reply as soon as possible.
Thank you in Advance.

Configuration: Windows XP
Firefox 2.0.0.20

Best answers for « Conditional Formatting Highlighting Row » in :
Conditional formating - apply on more cells Show
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...
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:...
Highlighting the current row ShowHighlighting the current row Issue Solution Adding it to a general module (eg Module1) Issue When you make conversion on a Excel sheet, you often loses the point of reference. Solution This little function highlights any line...
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 HP USB Disk Storage Format Tool ShowHP USB Disk Storage Format Tool is a small utility allowing to format a key USB or READER MP4. It also allows to make a key (Bootable). This software works with all keys and readers MP4 of the market. To make work this utility under Windows...
Download HDD Low Level Format Tool Show
Download Format Factory ShowFormat Factory is an application that allows conversion of various types of media files. It has various characteristics that allow you to customize a lot of stuff like: Convert video formats, audio and picture shows. Repair damaged files. Reduce...
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...
MKV format (Matroska Video) ShowMKV format The MKV format (Matroska Video) is an entirely free video format. More precisely, it is a container (hence the name Matroska, in reference to the Russian dolls contained within another) making it possible to contain video (DivX, Xvid,...
S/PDIF format ShowS/PDIF format The S/PDIF standard ("Sony/Philips Digital Interface", or SPDIF for short) is a digital audio data transfer format. It is an international standard known as "IEC-958 type II", which defines both hardware specifications (physical...
Ask your question Reply
They need your help