Previous Topic Next Topic

Conditional Formatting for 2 columns

Closed
NicA81 - Mar 1, 2016 at 10:12 AM
BrianGreen Posts 1010 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 - Mar 4, 2016 at 09:52 PM
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

Answer 1 / 1
BrianGreen Posts 1010 Registration date Saturday January 17, 2015 Status Moderator Last seen September 30, 2021 150
Mar 4, 2016 at 09:52 PM
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.
0