Conditional Formatting for 2 columns Closed

Question

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

BrianGreen · Answer

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.

Conditional Formatting for 2 columns

1 response

Subscribe To Our Newsletter!