Color cell

Posts
1
Registration date
Friday April 5, 2019
Status
Member
Last seen
April 5, 2019
- - Latest reply: ac3mark
Posts
13036
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
- Apr 5, 2019 at 01:09 PM
Hello,
I have this formula to place a date in cell when negative number.

=IF(D14<=-1,TODAY(),"")

I would like to add to the formula to change the cell color when there is a date present.

any help would be appreciated.
See more 

1 reply

Posts
13036
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1458
0
Thank you
Take a look here.

Respond to ac3mark