Conditional formatting incorrectly highlighting when using IFERROR

This post has been de-listed

It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.

solved

Post Body

I have a VLOOKUP in 2 columns where I'm pulling in hours. I have 2 conditional formulas ,

<40 it is just to bold and double underline,

>40 bold/double underline and highlight yellow

I placed an iferror in the formula, as I don't want it bringing back #n/a if no hours, as there's sums involved below, so it is supposed to bring back 0.00 instead, and #n/a's just bother me.

=IFERROR(VLOOKUP(D15,'Week 1 JDE Summary'!B:H,7,0),"0.00")

Prior to adding the iferror, these formatting's worked perfectly, however, only the greater than CF is causing an issue, where it's highlighting all hours that are pulling a 0.00 - because I don't all hours in yet.

IF CF >40

Any ideas what I am doing wrong?

Author

Account Strength

90%

Account Age

8 years

Verified Email

Yes

Verified Flair

Total Karma

1,493

Link Karma

1,335

Comment Karma

127

Profile updated: 2 days ago

Posts updated: 5 months ago

vancitynat

Subreddit

r/excel

Post Details

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.

Posted: 9 months ago
Reddit URL: View post on reddit.com
External URL: reddit.com/r/excel/comme...