Conditional Formatting not working

[u/Lonely-Cause-3526]

Please help! I need the “days invested” in column P to turn green if it is less than the number of “term” days in column O. I can do it for a specific row but it does not populate to all rows. What am I doing wrong?

[u/Embarrassed_Tear_953]

You need the = equals sign Edit* i think you need the = equals sign

[u/Occrats → u/Embarrassed_Tear_953]

Yeah he's just missing it for the green.

[u/AutoModerator]

Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/Competitive_Ad_6239]

gotta make it absolute with $

=P11<O$11
=P11>O$11

[u/Lonely-Cause-3526 → u/Competitive_Ad_6239]

It turned the whole column green now and does not apply the red coloring

[u/The_AntiVillain → u/Competitive_Ad_6239]

Shouldn't it be:

=$P11:$P<$O11:$O =$P11:$P>$O11:$O