Simple Excel Question

  Bazza Boy 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 29 Apr 11

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

  VoG II 29 Apr 11

Link didn't work link text

  VoG II 29 Apr 11

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

  Bazza Boy 02 May 11

Thanks so much VoG. Worked a treat!

Advertisement

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

Should I upgrade to Windows 10? 8 reasons why you should upgrade to Windows 10... and 2 why you…

We are being sold the ability to spend money we don't have. And we love it

Wacom Cintiq 27QHD review

How to use Apple Music in the UK: Complete guide to Apple Music's features

We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message