Previous Topic Next Topic

Conditional Formatting

Closed
TraceyLongstaff Posts 1 Registration date Tuesday 10 October 2017 Status Member Last seen 10 October 2017 - 10 Oct 2017 à 09:52
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 10 Oct 2017 à 10:21
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.
Related:

1 response

Réponse 1 / 1
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
10 Oct 2017 à 10:21
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

Similar discussions

Conditional Format Cells Based on Another Cell and Own Cell
Elaine -
x -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Conditional Formatting - highlight overdue dates
TanyaRT -
TanyaRT -

2 responses
Conditional formatting based text in another cell
y88y -
y88y -

2 responses