So the box in sheet VALID never changes, but the words does.
I need the cell-color to format after the list in sheet DATA. The problem is the list in DATA keeps growing, as I add new items?
Is there anyway to solve this?
Formatting.xlsx
So the box in sheet VALID never changes, but the words does.
I need the cell-color to format after the list in sheet DATA. The problem is the list in DATA keeps growing, as I add new items?
Is there anyway to solve this?
Formatting.xlsx
What is your CF criteria?
Quang PT
Hi @bebo021999
Condition is, if the word is in the list - the cell gets the corresponding color.
You mean CF of C2 in sheet data?
=COUNTIF(VALID!C:C,C2)>0
Like this:
Formatting (2).xlsx
The problem is, I keep adding word in sheet DATA
Last edited by horsefish01; 01-17-2016 at 05:55 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks