Cell conditional on outcome of another cell

sinternational

New member
Joined
Mar 7, 2019
Messages
7
Reaction score
0
Points
0
Excel Version(s)
2016
For example:

I have a list of companies and I need to know 30/60 days before that the accounts are due by inserting in the next cell the words "DUE-30 Days" and also in red.

So - 01/01/2019 then 30/60 days later the next box would be highlighted in red and showing "DUE-30 Days".

Thanks for you're help
 
HI
Thanks for that. I cant seem to get that working when I put into a CF.See attached if you can help further.
 

Attachments

  • box_red.xlsx
    14.3 KB · Views: 10
Back
Top