Hello and thanks for looking at my problem.
For some reason I cannot attach a file so I'll try to write it out and hope it makes sence.
Ok so here is the unsorted list (in a column) these are entered in the order they are done. Each number will only appear once as they are selected from a drop down list.
.......A
1 170115
2 170116
3 170117
4 170107
5 170108
6 170103
7 170104
8 170105
9 170101
10 170110
11 170111
12 170112
13 170113
14 170102
15
16
17
19
20
In another column list, lists all the number that need to be done. I would like the word Done in green or green background to appear in the adjacent cell when it is found in the first list and not until.
........G.......H
1 170101 DONE
2 170102
3 170103
4 170104
5 170105
6 170106
7 170107
8 170108
9 170109
10 170110
11 170111
12 170112
13 170113
14 170114
15 170115
16 170116
17 170117
18 170118
19 170119
20 170120
The conditional formatting I think I am ok with.
It is the IF statement I am struggling with. I have tried this by naming the first list as a range "list1" and also just by selecting the range A1:A20
These are what I have tried and do not work.
=IF(list1=G1,"Done","") Here I get the blank, the number 170101 is in the list and its refering to cell G1 which is in this case 170101 but its not finding it.
=IF(list1=170101,"Done","") Same as above but I specified the number.
=IF(A1:A20=170101,"Done","") Here I get the blank, the number is in the list but its not finding it and I specified the number 170101 I wanted it to find.
=IF(A1:A20="170101","Done","") Same as above with quotes around the number.
I probably need a different function I've not used before and don't know exists but I cannot seem to find a function that I need.
Please help.
Bookmarks