Thread: Conditional formatting to ignore zeros
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Conditional formatting to ignore zeros
Select your range
conditional formatting

Formula is: =A1<0

format any colors you like


"Jock" wrote:

Hi,
How do I get this:
=COUNTIF($D4,(MIN($D$4:$D$15)))
to ignore zero's?

--
Traa Dy Liooar

Jock
Reply With QuoteReply With Quote