Hi,
I want to use the cell entries only from a list. For example,
in sheet1 i have list of students in a class.
In sheet 2,3 and 4 i want to have their groups. So, entries in this
group
has always from the list in sheet1.
The Conditional formatting allows list to be only from the same sheet.
Can it be worked out to get the list elements from other sheet.