ExcelBanter - Truning 0 vaules red

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Truning 0 vaules red (https://www.excelbanter.com/excel-worksheet-functions/80927-truning-0-vaules-red.html)

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?

Gary''s Student

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?

All times are GMT +1. The time now is 11:00 PM.