Simple Excel Question

  Bazza Boy 09:18 AM 29 Apr 11

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 AM 29 Apr 11

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

  VoG II 09:24 AM 29 Apr 11

Link didn't work link text

  VoG II 09:25 AM 29 Apr 11


  Bazza Boy 09:32 AM 02 May 11

Thanks so much VoG. Worked a treat!


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

Toshiba dynaPad release date, price and specs: Another Surface Pro 4 rival with Windows 10

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

Google Maps for web gets a Material Design-inspired makeover

New Apple TV 2015 release date and UK price: buy from Apple in late October, in store in November