Thread: Conditional Formatting on #VALUE!
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Conditional Formatting on #VALUE!
Conditional Formatting

=ERROR.TYPE($A1)=3


"JE" wrote:

Is it possible to use conditional formatting if a cell is #VALUE!

I cannot locate a command the executes properly.

Many thanks.
Reply With QuoteReply With Quote