Report

Conditional Formatting

Ask a question TraceyLongstaff 1Posts Tuesday October 10, 2017Registration date October 10, 2017 Last seen - Last answered on Oct 10, 2017 at 10:21 AM by Mazzaropi
I wondered if you could assist please? I currently have a column of dates that change to a bold red if the date is past. However, I require the date to change back to black if the column to the right of it contains an X. Could you advise what the conditional formatting formula would be for this please? I look forward to getting your answer as I have been working on this spreadsheet for some time now and cannot seem to get it right. Thank you very much.
Helpful
+0
plus moins
TraceyLongstaff, Good morning.

Suppose your column of dates is A

Select the range of Column A you want; ex: A1:A25

Try to use this formula at your Conditional Formatting Formula:

=AND(TODAY()>A1, B1<>"x")

OK.

Please, tell us if it worked as you want.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!