I need to create a conditional formatting based on the value of the current cell and if that value is found in a column.
Example.
Cell A1 has a value of 8am-4pm.
If that value is also anywhere in column B then the conditional formatting would apply.
Thanks for any help.
Nick
Bookmarks