Conditional formating syntax help...

  • Thread starter Thread starter crew4beer
  • Start date Start date
C

crew4beer

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..
 
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>
 
Back
Top