# Color a cell if it meets 2 to assigned values in one other sheet.

1. ## Re: Color a cell if it meets 2 to assigned values in one other sheet.

thank you guys. the last one did not work after ii added more data in my 3 sheet.
not sure what the problem was.
I worked my way around it using sumifs and formated the cell to not show values only colors.
but its good to know that there is a easy way to solve this. this was my final document regarding this problem.

thanks for your help

2. ## Re: Color a cell if it meets 2 to assigned values in one other sheet.

Pl see attached file.
Formula for CF for cell S6

=ISNUMBER(MATCH(S\$4&\$C6,timeliste!\$A\$2:\$A\$10&timeliste!\$F\$2:\$F\$10,0))

Select S6:AR33
Apply formula as new rule.

Page 2 of 2 First 1 2

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1