I usd to think I was an Excel power user but I am stumped. If I put an equation into conditional formating it does not seem to take effect. As a test, I put the same equation in the cell contents, and it evaluates to TRUE. When I copy that same equation into the conditional formating equation, and select a cell shade format (eg Red), it doesn't do it. Any ideas? I am willing to send the example to anyone who wants to look at it.