forget this i find the way, just copy the first cel with the conditional formatting, along with the reference code for each line to return true or false
Hui, yes they do.
This is the combo table
Title list
B B2
C C3
D D3
E E4
All the cells are combo box.
The info for the first is from here
title
B
C
D
E
And for the second one it will check this table
title list
B B1
B B2
B B3
B B4
B B5
B B6
B B7
B B8
0
0
C...
Hi Hui, yes the first column lookup for the same value.
it works like this:
title B C title list
B B1 C1 B B1 Title list
C B2 C2 B B2 B B2
D B3 C3 B B3 C C3
E B4 C4 B B4 D D3
B5 C5 B B5 E E4
B6 B B6
B7 B B7
B8 B B8
0
0
C C1
D E C C2
D1 E1 C C3
D2 E2 C...
Hi everyone, first of all sorry if my English isn’t the best, i’m Portuguese.
I’m new to the forum and i’m learning excel from my own. I’m trying to make a personal budged worksheet.
The problem i have now is this:
I have 2 columns and every cel of those 2 columns are combo box , the same...