question by: BabyGazelle
Conditional formatting based on value in another column
Column A has ETA dates. I have conditional formatting specifying to turn the cell red if the date is past due. However, in Column B, I have data validation with a list of Statuses, and I want it so that if Complete is select in column B then the color fill for the date in column A is white (instead of red). Since it isn't "past due (it's Complete!).