Simple Excel Question

  Bazza Boy 09:18 29 Apr 11
Locked

Hi everyone

First question, so please be gentle.

I have 3 columns of numbers in Excel - all populated via VLookup formulae.

Do you know how I can write something to compare these to a few numbers in a row at the top of my s/sheet, and flag if less than? I just don't want to stuff up my VLook up formula

Thanks so much

  VoG II 09:24 29 Apr 11

Perhaps you could use Conditional Formatting to colour them. This tutorial may help link text

  VoG II 09:24 29 Apr 11

Link didn't work link text

  VoG II 09:25 29 Apr 11

Hmm http://www.contextures.com/xlCondFormat02.html

  Bazza Boy 09:32 02 May 11

Thanks so much VoG. Worked a treat!

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

The updated 'Corel Painter inside Photoshop' plugin ParticleShop offers new brushes

New MacBook Pro 2017 release date, UK price and tech specs: Kaby Lake MacBook Pro to launch in…