View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sloth Sloth is offline
external usenet poster
 
Posts: 252
Default Conditional Formatting

Click Format-Conditional Formatting
Select "Cell Value is"
and "not equal to"
enter the formula as the condition.
click Format and select the properties you want.

Not exactly what you wanted, but I think it should work until someone
provides you with a better solution.