View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default If data in one column, take date, add 2 days, and turn the entire

Select entire sheet (A1 active)
Click Format Conditional Formatting
Under Condition 1, make it as:
Formula is: =AND($A1<"",$E1<"",$A1<TODAY())
Format the trigger fill color to taste OK out
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
" wrote:
I have two columns setup... Column A would have a received date and
Column E would have a name. What I'm looking to do is if there is a
name filled in in Column E (any data at all), then take Column A and
add two days. If it's past due (example: Column A has 8/01/06, today is
8/22/06, so it would be past due), then turn the entire row a selected
color.

Is this possible? Thanks!