View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bz
 
Posts: n/a
Default Turning 0.000 values red

I have the following formula
=INDEX('DRG Weights'!$J:$J,MATCH(Charts!$G:$G,'DRG Weights'!$A:$A,0))

When I get a caculated value of 0.000 how can I make it turn red?