Problems with conditional formatting and cells with VLOOKUP.

**Gaztr1x** · 08-13-2013, 05:39 AM

Hi. Im having problems with conditional formatting and cells with VLOOKUP. Here is my table. snip.JPG

I have two conditional formats on the cumulative column to turn cells red. The two formula are:
1) =AND(G44="Test",I44>2)
2) =AND(G44="sample",I44>5)

G = product description column
I = Cumulative column
44 = First row under the headers

This seems to work perfectly if I type the product description in manually into column G. However these are the product of a VLOOKUP formula and I can not get it to work. The VLOOKUP formula in the product description column is:
=IF(D44>0,(VLOOKUP(D44,standard,2)),0)

D= Code column
standard = 2nd sperate excell worksheet

Any help would be great.

Thanks

**protonLeah** · 08-14-2013, 12:35 AM

To attach a Workbook
(please do not post pictures of worksheets)

Click Advanced (next to quick post),
Scroll down until you see "Manage Attachments",
Click that then select "add files" (top right corner).
Click "Select Files" find your file, click "open" click "upload"
Once the upload is completed the file name will appear below the input boxes in this window.
Click "Done" at bottom right to close the Attachment Manager.
Click "Submit Reply"

**FDibbins** · 08-14-2013, 12:42 AM

In 2007, CF does not allow referencing another worksheet. Either pull in the reference to the sheet where you want the CF, or create a named range for the reference and use that in the CF