Thursday, February 15, 2018

yogi_Conditionally Format Projects That Are 'Not Complete' And Those 'In Progress' As Of Today

Google Spreadsheet   Post  #2369

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Feb-15-2018

question by: BabyGazelle
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/nD2MIoKqoeI;context-place=mydiscussions
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!).

Howe do I do this?