Hi
I hope someone can help me?
I need to do conditional formatting on a cell. I have cell O4 with a date in i.e. 9/9/20, and I need it to got red if the date more than 1 year passed and blue if it is 6 months passed.
The formula i have done is: =$O$4<=TODAY()-182
but if i do another for 365 it override this one.
again it feels that i am making it more difficult than needed
Regards
Matthew
I hope someone can help me?
I need to do conditional formatting on a cell. I have cell O4 with a date in i.e. 9/9/20, and I need it to got red if the date more than 1 year passed and blue if it is 6 months passed.
The formula i have done is: =$O$4<=TODAY()-182
but if i do another for 365 it override this one.
again it feels that i am making it more difficult than needed
Regards
Matthew