View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Jim is offline
external usenet poster
 
Posts: 615
Default Conditional Formatting Questions

Hello,

I have a conditional format set in A, B, C and D to go bold if E is empty.
The formula looks like this: =$E1533=""

Cell A holds the date the line was completed

When setting up a second condition I would like cells A, B, C and D to go
red when todays date is seven or more days from the entry date shown in the A
cell.

Also, I need the red to not appear anymore once data has been entered in the
E cell.

Thanks for the help.
Jim