|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 3rd, 2008, 08:16 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting
how do i write a formula for a cell that i want to format if the date entered
into the cell is within 7 days beyond a date in another cell. -- Anne 
|
|
#2
September 3rd, 2008, 08:36 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting
Anne wrote:
how do i write a formula for a cell that i want to format if the date entered into the cell is within 7 days beyond a date in another cell. Because Excel stores dates as numbers, you would write this exactly the same way as "if the number entered into the cell is within 7 beyond a number in another cell". So, if I understand correctly, to format cell A1 based upon the entry in B1: Cell Value Is less than or equal to =B1+7
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
