Conditional Formatting

I was hoping you could assist me with a similar problem? My spread sheet has membership dates in one column and expiry dates in the adjoining, I had it set up so if the exoiry dates were exceeded, the cells high lighted with a red fill. This no longer seems to be working, could you help me please? Nauthstar 

I have a similar problem I think.  Ultimately, I want a cell to be yellow UNLESS a set of complex conditions occur (complex in how I have to strip out certain data from one column and compare to data in another column).  I initially used conditional formatting looking for some data in a row to apply simple formatting (border, yellow fill).  Then I added another rule with the complex conditions above hoping that it would override the yellow fill with the red fill.  I played with adjusting the order in which the rules would run but that does not seem to have any effect.  Each rule works (tested) but the rule I added last will not override the first rule.  In other words, once the rule to apply the yellow fill, the rule that conducts the additional testing will not then change the fill to red.  So the complex rule also checks for some data in a row, then further evaluates data in a particular column in the row (does some date comparisons which determines if the current date is 30 days after a date pulled from another cell AND there is no currency data yet provided in that cell).  This rule needs to be applied to every row in the worksheet (applied to multiple columns).  Although I haven't yet added an additional criteria since I have to confirm the business rule that would trigger the condition, but there will have to be a trigger in a (different) cell that checks the same thing but ALSO checks to see if a particular value has been entered in that cell.

Keep in mind this is a spreadsheet used by users that are not Excel "experts" and I do try to use the simplest method of achieving something (to try to prevent someone from deleting data, a column, using an invalid value that is being tested, etc.).

What are my options?  I know I could do this easily in VB but the owner of the spreadsheet would not be comfortable owning a spreadsheet with VB in it.  Also, I work for the government and I do run into security issues trying to implement VB even though it would not be used outside my team (theoretically).

Same spreadsheet, different question.  Is there a "simple" way to dynamically add a formula to a column in a row when data is added to a different column (without manually copying the formula to the target column in the new row)?  Again, I could do this with VB but same concern as above.