Formula to show if days are under 365

[LindsayBiss]

Hello,

I was looking to see if someone would know a formula to put in column N that will tell me if the numbers in column M are less then 360?

Is there a formula that could fill the cell in column N green if the number of days is less than 360, and red if it is over?

Thank you for you help !!

 

[6StringJazzer]

Highlight column N. Then go to Conditional Formatting and add a new rule that uses a formula:

=AND(M<>"",M<360)

fill green

add another rule:

=AND(M>=360)

fill red

You just said over or under, but did not mention equals. Adjust formulas to suit.

 

[Peter_SSs]

@6StringJazzer
I think those formulas would need some row numbers.
The second one would not need the AND either.

@LindsayBiss
I'm assuming the numbers in column M start at row 2. Select N2 down to wherever you want the colours to finish and then apply these Conditional Formatting formula rules.
Again you may need to adjust one of the rules to cover the 360 value itself.

23 11 18.xlsm
	M	N
1
2	78
3	52
4	398
5	200
6	412
7
8	399
9	355
10
Red Green

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
N2:N10	Expression	=M2>360	text	NO
N2:N10	Expression	=AND(M2<>"",M2<360)	text	NO

 

[6StringJazzer]

I think those formulas would need some row numbers.

Maybe in your version of Excel!

Just kidding.

The second one would not need the AND either.

You know, I should just quit for the day.

 

[LindsayBiss]

It Worked !!!

Thank you both very much for your help~!

Have a great day!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.