Hello, I have a spreadsheet where i have one column that contains either Submit or Retain the folloing to columns have a date in them. What i am try to do is look at the column with Submit or Retain, then format the date column text to change from either black or white.

The criteria is that if the cell contains Retain then the date column text should be Black and it the cell contains Submit then the date text should be White

Thanks