Cell Formatting After VLookup Is Done

B

BenjieLop

Here are the given data

NAME OBJECTIVE ACTUAL
Jones 150 159
Smith 150 172
Ashby 150 146
Brown 150 152
Aaron 150 142


In the summary, I need to enter the NAME (say, in Column D) and i
Column E, the corresponding entry in the ACTUAL column will be looke
up. I can do this with no problem.

Here is where I need help.

If the ACTUAL value looked up in Column E is less than the OBJECTIV
(from Column B), I want the entry to be RED in color. Otherwise, i
ACTUAL>=OBJECTIVE, the cell entry will just remain black in color.

Thanks in advance for any help
 
F

Frank Kabel

Hi
use conditional format for this. e.g.
- select cells E2:E20
- goto 'Format - Conditional Format'
- enter the following formula
=$E2<$B2
- choose a format (red color)
 
B

BenjieLop

Hello Frank,

Thank you as always. You are truly a lifesaver.

More power to you and regards
 
Top