Hello Everyone,
I am trying to use Conditional Formatting...
Our goal is to have clients with viral load results less than 200,
When a client's viral load lab result is greater than 200, there should be an X in front of the lab results (see below)
When a client's viral load lab result is 0 there should be an ! in front of the lab results (see below)
After I enter and apply my formatting rule, I see the Xs and !s, so I save the data, close the excel spreadsheet, then reopen it, the icons (Xand !) are gone....
How do I prevent this from happening? What am I doing wrong? Should I be using another feature?
[TABLE="width: 441"]
<tbody>[TR]
[TD]Client ID[/TD]
[TD] Name[/TD]
[TD]Age[/TD]
[TD]Gender[/TD]
[TD]VL[/TD]
[TD]VL DATE[/TD]
[/TR]
[TR]
[TD="align: right"]307240[/TD]
[TD] DOE, DORA[/TD]
[TD]40[/TD]
[TD]Female[/TD]
[TD]X691000[/TD]
[TD]3/16/2018[/TD]
[/TR]
[TR]
[TD="align: right"]10594294[/TD]
[TD] DOE, JANE[/TD]
[TD]47[/TD]
[TD]Female[/TD]
[TD]X497000[/TD]
[TD]1/26/2018[/TD]
[/TR]
[TR]
[TD="align: right"]311242[/TD]
[TD] DOE, JUNE[/TD]
[TD]28[/TD]
[TD]Female[/TD]
[TD]X295931[/TD]
[TD]11/7/2017[/TD]
[/TR]
[TR]
[TD="align: right"]310665[/TD]
[TD] DOE, DONNA[/TD]
[TD]43[/TD]
[TD]Female[/TD]
[TD]X258000[/TD]
[TD]7/14/2017[/TD]
[/TR]
[TR]
[TD="align: right"]309849[/TD]
[TD] DOE, DIANE[/TD]
[TD]29[/TD]
[TD]Female[/TD]
[TD]X223654[/TD]
[TD]9/26/2016[/TD]
[/TR]
[TR]
[TD="align: right"]14612050[/TD]
[TD] DOE, DINA[/TD]
[TD]16[/TD]
[TD]Female[/TD]
[TD]X217000[/TD]
[TD]3/7/2018[/TD]
[/TR]
[TR]
[TD="align: right"]310853[/TD]
[TD] DOE, DION[/TD]
[TD]5[/TD]
[TD]Female[/TD]
[TD]20[/TD]
[TD]2/21/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11821774[/TD]
[TD] DOE, DAYNE[/TD]
[TD]38[/TD]
[TD]Female[/TD]
[TD]20[/TD]
[TD]9/18/2017[/TD]
[/TR]
[TR]
[TD="align: right"]310054[/TD]
[TD] DOE, DESI[/TD]
[TD]60[/TD]
[TD]Female[/TD]
[TD]20[/TD]
[TD]3/30/2018[/TD]
[/TR]
[TR]
[TD="align: right"]306372[/TD]
[TD] DOE, DEE[/TD]
[TD]54[/TD]
[TD]Female[/TD]
[TD]20[/TD]
[TD]11/9/2017[/TD]
[/TR]
[TR]
[TD="align: right"]312048[/TD]
[TD] DOE, JOHN[/TD]
[TD]18[/TD]
[TD]Male[/TD]
[TD]!0[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]6203[/TD]
[TD] DOE, JAKE[/TD]
[TD]23[/TD]
[TD]Male[/TD]
[TD]!0[/TD]
[TD] [/TD]
[/TR]
</tbody><colgroup><col><col><col span="2"><col><col></colgroup>[/TABLE]
I am trying to use Conditional Formatting...
Our goal is to have clients with viral load results less than 200,
When a client's viral load lab result is greater than 200, there should be an X in front of the lab results (see below)
When a client's viral load lab result is 0 there should be an ! in front of the lab results (see below)
After I enter and apply my formatting rule, I see the Xs and !s, so I save the data, close the excel spreadsheet, then reopen it, the icons (Xand !) are gone....
How do I prevent this from happening? What am I doing wrong? Should I be using another feature?
[TABLE="width: 441"]
<tbody>[TR]
[TD]Client ID[/TD]
[TD] Name[/TD]
[TD]Age[/TD]
[TD]Gender[/TD]
[TD]VL[/TD]
[TD]VL DATE[/TD]
[/TR]
[TR]
[TD="align: right"]307240[/TD]
[TD] DOE, DORA[/TD]
[TD]40[/TD]
[TD]Female[/TD]
[TD]X691000[/TD]
[TD]3/16/2018[/TD]
[/TR]
[TR]
[TD="align: right"]10594294[/TD]
[TD] DOE, JANE[/TD]
[TD]47[/TD]
[TD]Female[/TD]
[TD]X497000[/TD]
[TD]1/26/2018[/TD]
[/TR]
[TR]
[TD="align: right"]311242[/TD]
[TD] DOE, JUNE[/TD]
[TD]28[/TD]
[TD]Female[/TD]
[TD]X295931[/TD]
[TD]11/7/2017[/TD]
[/TR]
[TR]
[TD="align: right"]310665[/TD]
[TD] DOE, DONNA[/TD]
[TD]43[/TD]
[TD]Female[/TD]
[TD]X258000[/TD]
[TD]7/14/2017[/TD]
[/TR]
[TR]
[TD="align: right"]309849[/TD]
[TD] DOE, DIANE[/TD]
[TD]29[/TD]
[TD]Female[/TD]
[TD]X223654[/TD]
[TD]9/26/2016[/TD]
[/TR]
[TR]
[TD="align: right"]14612050[/TD]
[TD] DOE, DINA[/TD]
[TD]16[/TD]
[TD]Female[/TD]
[TD]X217000[/TD]
[TD]3/7/2018[/TD]
[/TR]
[TR]
[TD="align: right"]310853[/TD]
[TD] DOE, DION[/TD]
[TD]5[/TD]
[TD]Female[/TD]
[TD]20[/TD]
[TD]2/21/2018[/TD]
[/TR]
[TR]
[TD="align: right"]11821774[/TD]
[TD] DOE, DAYNE[/TD]
[TD]38[/TD]
[TD]Female[/TD]
[TD]20[/TD]
[TD]9/18/2017[/TD]
[/TR]
[TR]
[TD="align: right"]310054[/TD]
[TD] DOE, DESI[/TD]
[TD]60[/TD]
[TD]Female[/TD]
[TD]20[/TD]
[TD]3/30/2018[/TD]
[/TR]
[TR]
[TD="align: right"]306372[/TD]
[TD] DOE, DEE[/TD]
[TD]54[/TD]
[TD]Female[/TD]
[TD]20[/TD]
[TD]11/9/2017[/TD]
[/TR]
[TR]
[TD="align: right"]312048[/TD]
[TD] DOE, JOHN[/TD]
[TD]18[/TD]
[TD]Male[/TD]
[TD]!0[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]6203[/TD]
[TD] DOE, JAKE[/TD]
[TD]23[/TD]
[TD]Male[/TD]
[TD]!0[/TD]
[TD] [/TD]
[/TR]
</tbody><colgroup><col><col><col span="2"><col><col></colgroup>[/TABLE]