Conditional formating if cell is either 2 or 3 over Vlookup number.

[wkirkcrawford]

Greetings,

I have a spread sheet that I use as my log keeping Blood Sugar Readings. It uses Vlookup and it works.

But now I'm allowed to take addtional 2 or 3 units of insulin, My Choice over what Vlookup returns.
By the way, 2 is a light color, and 3 is a darker color.

If VLOOKUP returns a number, the color is clear or white.

If I change that number by eithre 2 or 3, then it should changes color.

This Conditional Formating cell worked. =IF((V17)="","",VLOOKUP(V17,$AV$5:$AW$10,2,1))+5 Ingor cell range AV5:AW10.

But It's not working with this.

And help will be appreacated.

W. Kirk Crawford
Tularosa, New Mexico

 

[wkirkcrawford]

Greetings,

I got most of it to work. But I have one cell that isn't responding to the Conditional Formating.

The VLOOKUP returns a number of 0, which VLOOKUP is correct. I've changed it to 2. It should change color. If I chance to cell to 3, it changes color for 2 units insted of 3.

The cell above and below it is correct.

Here is what I have now, =IF((O21)="","",VLOOKUP(O21,$AW$9:$AX$14,2,1))+2

I've included a screen shot of what I'm trying achive.

Any help?

W. Kirk Crawford
Tularosa, New Mexico

 

[wkirkcrawford]

Greetings,

I can't this Conditional Format to work.

This is what I have so far, =IF(($O21)="","",VLOOKUP($O21,$AZ$9:$BA$14,2,1))+2
And this one. =IF(($O21)="","",VLOOKUP($O21,$AZ$9:$BA$14,2,1))+3

Does the fact that there is a "0" as a result of VLOOKUP? Also, the Conditional Formating isn't work just right.

If the VLOOKUP return a number, I have My Choice to change it by either 2 or 3.

I have a similar formula that works fine.

What’s wrong with this one?

W. Kirk Crawford
Tularosa, New Mexico