| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Truning 0 vaules red
use conditional formatting
-- Gary''s Student "bz" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy/paste vaules, not formulas | New Users to Excel | |||
| copy/paste vaules, not formulas | New Users to Excel | |||
Hybrid Mode
