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?
<tbody>
</tbody><colgroup><col><col><col span="2"><col><col></colgroup>
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?
Client ID | Name | Age | Gender | VL | VL DATE |
307240 | DOE, DORA | 40 | Female | X691000 | 3/16/2018 |
10594294 | DOE, JANE | 47 | Female | X497000 | 1/26/2018 |
311242 | DOE, JUNE | 28 | Female | X295931 | 11/7/2017 |
310665 | DOE, DONNA | 43 | Female | X258000 | 7/14/2017 |
309849 | DOE, DIANE | 29 | Female | X223654 | 9/26/2016 |
14612050 | DOE, DINA | 16 | Female | X217000 | 3/7/2018 |
310853 | DOE, DION | 5 | Female | 20 | 2/21/2018 |
11821774 | DOE, DAYNE | 38 | Female | 20 | 9/18/2017 |
310054 | DOE, DESI | 60 | Female | 20 | 3/30/2018 |
306372 | DOE, DEE | 54 | Female | 20 | 11/9/2017 |
312048 | DOE, JOHN | 18 | Male | !0 | |
6203 | DOE, JAKE | 23 | Male | !0 |
<tbody>
</tbody><colgroup><col><col><col span="2"><col><col></colgroup>