Forum Discussion
Work Schedule Help
I have a work Schedule, I have it set up where I use to show a person name as White if they are on the schedule and red if not on the schedule. This issue I am having is sometimes we need to show tex...
I attached the Conditional Formatting picture and I am using version 365 MSO (Version 2202 Build 16.0.14931.20648) 32-bit
eanastasio Thanks! It seems you are looking for Duplicate Values and that, of course, will not work as "FLAX" is not a duplicate of "FLAX 23:00".
Therefore you need to use a FIND function as that allows you to find partial text strings as shown in my example. FIND will return a number if a sub-string is found or an error if not. Using the IF(ISNUMBER(....) allows you to return a 1 if found and 0 if not.
But it's difficult to give you the exact solution without your file.