Thread: Truning 0 vaules red
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bz
 
Posts: n/a
Default Truning 0 vaules red
I am using the following formula

=INDEX('DRG Weights'!$J:$J,MATCH(Charts!$G:$G,'DRG Weights'!$A:$A,0))

When the caculated value is 0.000 I want it to turn red. How can I do this?
Reply With QuoteReply With Quote