Conditional formating syntax help...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

crew4beer@hotmail.com - 26 Oct 2007 03:06 GMT

HI All,

A simple one I know but I'm perplexed...

I would like to have the ability ot enter a number on a spreadsheet
and then LOOKUP that number on a sperate worksheet and if it is there
for the entered number to change colours, Green in this case.

If the number is NOT on the second worksheet, I wouls like it to turn
display in RED.

Thanks in advance

G..

Reply to this Message

JE McGimpsey - 26 Oct 2007 05:07 GMT

One way:

Name your lookup range in the second sheet, say, LookupRange.

Then in Sheet1 enter this (say cell A1 is active):

CF1: Formula is =AND(A1<>"",ISNA(MATCH(A1,LookupRange,FALSE)))
Format1: <font>/<red>

CF2: Formula is =LEN(TRIM(A1))>0
Format2: <font>/<green>

> HI All,
>
[quoted text clipped - 10 lines]
>
> G..

Reply to this Message