Conditional Formatting

Closed

TraceyLongstaff Posts 1 Registration date Tuesday October 10, 2017 Status Member Last seen October 10, 2017 - Oct 10, 2017 at 09:52 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 10, 2017 at 10:21 AM

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.

Conditional Formatting
How to clear formatting in excel - Guide
Excel conditional formatting if another cell contains specific text - Excel Forum
Excel formula to change cell color without conditional formatting - Excel Forum
To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
Phone formatting software for pc - Download - File management

1 response

Answer 1 / 1

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Oct 10, 2017 at 10:21 AM

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

How to use conditional format based on text?

Highlight cell if another cell contains specific text

Highlight cell if another cell contains any text

Conditional formating - apply on more cells

one cell will turn green when the two other cells match

Similar discussions

Subscribe To Our Newsletter!