Conditional Formatting

[Manny74]

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?

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>

 

[Joe4]

Please post the exact Conditional Formatting rules that you are using.

When you re-open your sheet, are the Conditional Formatting rules still there?
What format are you saving the file in?

 

[Manny74]

I tried to take a screen shot, save it as a pdf file, but am having trouble attaching it to my thread since it wants the URL?

 

[Joe4]

You cannot attach files to this site.
Are you using Conditional Formatting formulas? If so, just please copy and paste them here.
Also, please be sure to answer the two questions at the bottom of my previous post.