Conditional Formatting for 2 columns

[Closed]
Report
-
Posts
1004
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
November 27, 2020
-
Hi

I am currently using conditional formatting on cells with dates, I have used cell value rules to highlight a pending date within 14 days and one to highlight a date which has passed.
But I also want to add an IF statement rule which looks another field highlight the date in green if the date has passed but I have a "Y" in another field.

i.e. the fact that I have received there is a Y checks precedence over the fact the date has passed.

any clues on how to write this, I have used the below but it hasn't worked

=IF=($N:$N="Y")
N

1 reply

Posts
1004
Registration date
Saturday January 17, 2015
Status
Moderator
Last seen
November 27, 2020
138
Hi NicA81,

You could try adding another Conditional formatting rule to the date cell:

1. Select the date cell you want to conditional format.
2. Click Conditional Formatting from the top ribbon.
3. Select New Rule.
4. Click "Use a formula to determine which cells to format".
5. In the "Format values where this formula is true" section type =[addess od cell you have a Y in]=Y=TRUE
6. Click the [Format] button followed by the "fill" tab and select a shade of highlight you like.
7. Click the [OK] button and again click the [OK] button.
8. Finally put a tick in the "Stop if true" boxes at the end of each line and then click the [OK] button.

Hopefully you will now have what you need. Please let me know how you get on.