Thread: Conditional Formatting on #VALUE!
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
  
Posts: 1,240
Default Conditional Formatting on #VALUE!
JE wrote:
Is it possible to use conditional formatting if a cell is #VALUE!

I cannot locate a command the executes properly.

Many thanks.


Use ERROR.TYPE(yourcell)=3 in the conditional format.
Reply With QuoteReply With Quote