I understand conditional formatting but I don't see how it can help me. I'm looking at a sheet with many product entries and for most of them I get values from a table (
vlookup) while for others I punch them in.
Cell b2 contents are
=vlookup(a2,range,2,false)and what is displayed is
Cell b3 I know
vlookupwill fail (there is no data for the product in the range for a3) so I manually put in
With over a hundred lines like this how can I program a highlight/Format condition to visually distinguish between those that were introduced manually from those retrieved with