Simple Excel Question

  Bazza Boy 09:18 29 Apr 2011
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 2011

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

  VoG II 09:24 29 Apr 2011

Link didn't work link text

  VoG II 09:25 29 Apr 2011

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

  Bazza Boy 09:32 02 May 2011

Thanks so much VoG. Worked a treat!

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

Elsewhere on IDG sites

Acer Predator 21X review

Game of Thrones GIFs: how Eran Mendel is creating hilarious weekly GIFs based on each episode's…

How to increase storage on iPhone

Nokia 8 : rumeurs & soirée de lancement