Is there a way to identify specific date ranges (color code). example: if sales were before January 1, 2015 color blue and if after January 1, 2015color red.
Something like this would work.
IF [Order Date] < DATE("1/1/2013") THEN "Blue" ELSE "Orange" END
9.0 workbook attached.
Perfect! Thank you! This works great!
Retrieving data ...