I am attaching a sample of a page from an incomplete workbook. I want to assign jobsites to various employees; that is done on a different worksheet. The attached sheet is a sampe of the sheet that employees view to see their assignments; a pink cell = a full-day job, a blue cell = a multi-day job and a yellow cell = an unfinished job. I can only use 3 colours b/c conditional formatting only permits 3 items; the cell colour is triggered by placing asterisks in front of the person's name.
In the attached file, you will see on Jan 4, Mr. Black is at job site 1 (an all day job). Black cannot see the lower 1/2 of the page; he looks at the upper 1/2, under his name, to see where he is assigned, in cell J8.
I tried to use a COUNTIF($F26:$L26,J20)=1 formula to turn cell J8 blue, but it doesn't work...maybe b/c the asterisks are wildcards..??...I don't know....but I need a formula for use in conditional formatting that will cause J8 to turn blue, or, cell I8 to turn yellow based on G27 being ***White........any suggestions ??...thanks....see sample attached