Well, firstly I am a novice in Excel, but still I thought I could try.
How about, conditional formatting in a different way. Having the result
of the VLOOKUP in a cell say $C$50 & in conditional formatting, have
the values set equal to $C$50 & format

RagDyer wrote:
You're talking in generalities.

Give some *exact* problems and/or *exact* data values that you foresee you
would not be able to *easily and quickly* revise to suit your needs.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"JAZZNAURA" wrote
in message ...

Thanks for the reply,

Tried RagDyer's suggestion works but doesn't give me the flexibility I
need. Would have to format a lot of cells on a daily bases as most have
different values. ABOUT 4000 CELLS :(

Hope someone can help with a macro. ANYBODY !!!!! ;)


--
JAZZNAURA
------------------------------------------------------------------------
JAZZNAURA's Profile:
http://www.excelforum.com/member.php...o&userid=36961
View this thread: http://www.excelforum.com/showthread...hreadid=572793