That will only format cells with errors white, not cells without errors
(I tested on my own spreadsheet). Since we don't know what your data
consists of, it makes it difficult to ensure a solution will workk for
you.

Seeing an example of your sheet would be helpful as well as ALL the
conditions that you are looking to apply. CF can be tricky if you
don't enter in the conditions in the correct order when using
multiple.


Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=503494