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!