Forum Discussion
Profit/Loss per Day Calendar
Hi All, I am looking for formula for these 2 items. 1. Want total Profit/Loss per date in Calendar (E.g. Total Profit on 02 Feb 2022 was -90.65). 2. If Profit Cell to be Green, If Loss cell to ...
That is because the formula specified a specific range that matches the data.
I have modified HansVogelaar's workbook to use a table for the profit/loss data that should resize as data is appended. The names are defined in terms of table structured references.
The missing attachment:
PeterBartholomew1 I figured it out with the Cnt + H method that Hanz mentioned back in 22, thank you for your response!!