I have read other threads that are similar to what I need, but none of them are working due to my displayed date issues. Is is possible in Excel 2013 to set a conditional formatting rule to highlight cells in column C & D based on the displayed information in column B instead of actual data?
In Column B I have dates entered in as mm/dd/yy number format, but displayed as Day of the week, Month, Date, Year (example: 02/03/14 displays as Monday, January 3, 2014). I want to highlight the cells next to it based on the displayed text, not the numbers behind it.
My goal is to highlight the cells in column C-H if the dates in column B of the same row show either Saturday or Sunday. My first thought was to truncate the first three letters from each cell in column C into empty column A (showing as Thu Fri, etc) and reference that in my conditional formatting formula, but the LEFT function wants to grab the numbers and not the words from column B.
