Hi, I'm using office 2007 and this is a 2 part question

1. I'm trying to create a conditional formatting statement that will highlight a whole row if a certain cell in that row is TRUE,

2. I'm trying to work out how to create a macro that will save the document with a different file name if a row is highlighted ( - Negative and - Postive).

Thanks a lot for your help guys.. hope these questions are not too simple for you