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?
No comments:
Post a Comment