Thread: Condition format a row based on a formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default 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
---
Reply With QuoteReply With Quote