Another question:

So I have a cell (G1) which I have added a formula to say that when cell J5 equals "base-user", G1 becomes yellow (the background fill)....now I want to make it so that when J5 says "Shared", cell G1 becomes another colour (orange).

In cell J5 i have a drop down so that you can choose either "base-user" or "shared"

The first rule works fine so I naturally used the same procedure for the second rule....I have clicked on the cell i want to format (G1) and then gone through conditional formatting-->new rule-->Use a formula to determine...-->then in the formula space I typed: =$J$5="Shared" and then formatted for backfill colour. I made sure "Shared" was written the same.

It hasn't worked...not sure why???