Hello.. I am using the following look up: =VLOOKUP(A2,ESPN!$C:F,2,FALSE) to return a value from another sheet. The value it's returning is from a table that's being refreshed from the web, and could change every 60 Seconds. I am trying to use conditional formatting based on what the value is at the time, but I can't get it to work. I've read how to use CF based on a vlookup but I can't get it to work. I don't know if it's an issue the value always refreshing, or the formula I am using in the Conditional Format.
Bookmarks