|I don't have 2007 on the machine I'm sitting at, so I can't give you the exact steps to apply the Rule, but in 2003 if I use CF on A1 (or A2) and use a simple formula such as this, the CF will be applied.|
If I recall correctly, it's something like this in 2007:
1 - From the Ribbon select Home - Styles - Conditional Formatting,
2 - From the drop down select 'Manage Rules' and select 'New Rule'
3 - In the dialog box select the last item in the list 'Use a formula to determine which cells to format'
4 - Enter your formula in the box.
6 - Click the format button and from the 'Fill' Tab select a color, OK your way out.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.