Forum Discussion
Need help with conditional formatting equation
I am trying to format a cell based on the name in column D if the cells are between the dates shown in column B and C. For instance in row 14, I would like to have L14 through R14 formatted to a spe...
Hi Mike,
If in row 2 your numbers are actual dates formatted with custom format "d" when you may use the rule
=(L$2>=$B14)*(L$2<=$C14)*($D14="Turner")
(take care about absolute and relative references) applied to you range, e.g.
=$L$14:$W$26
Such rule shall be repeated for each name (other words color), as many you have them. Sample