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

wkirkcrawford

Board Regular
Joined
Dec 7, 2013
Messages
72
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
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
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
 

Attachments

  • 2022-02-24.png
    2022-02-24.png
    184.3 KB · Views: 18
Upvote 0
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
 

Attachments

  • 2022-02-24.png
    2022-02-24.png
    195.2 KB · Views: 13
Upvote 0

Forum statistics

Threads
1,223,239
Messages
6,170,947
Members
452,368
Latest member
jayp2104

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top