Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Condition format a row based on a formula
I need to conditional format any row in red based on if the date in one cell
is less than 60 days from the date in another cell. What is the formula I use? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Condition format a row based on a formula
"Tysmema" wrote:
I need to conditional format any row in red based on if the date in one cell is less than 60 days from the date in another cell. What is the formula I use? Assume start/earlier dates in A1 down, end/later dates in B1 down Select entire sheet, then apply CF using formula is: =AND(COUNT($A1:$B1),$B1-$A1<60) Format to taste OK out -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Condition format a row based on a formula
Hi Tysmema
Select the row you like to change colour and Conditional Format formula is :eg: =$A$1<$B$1-60 change cell reference to your need. Regards Cimjet "Tysmema" wrote in message ... I need to conditional format any row in red based on if the date in one cell is less than 60 days from the date in another cell. What is the formula I use? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Condition format a row based on a formula | Excel Worksheet Functions | |||
Condition font color in a single cell based on its formula data. | Excel Worksheet Functions | |||
Formula for Inputing a Value based on a Condition | Excel Worksheet Functions | |||
Condition Format a Day that resulted from a formula | Excel Discussion (Misc queries) | |||
format group of rows based on condition | Excel Discussion (Misc queries) |