Oh!Calcutta
New Member
- Joined
- Jun 15, 2011
- Messages
- 26
My Financial Data has the following column headings:
Col A : Shares of xxxx Co
Col B: No. of Shares
Col C: Date of investment (dd/mm/yyyy)
Col D: Amount paid
Col E: Date of Sale
Col F: Amount Received
Col G: Period held [using = Datedif(C,E)]
Col H: Gain/Loss [diff of Col D and Col F]
I want to highlight data as follows:
If Col G is > 12 months then Col H Green
If Col G is < 12 months then Col H Yellow
Col A : Shares of xxxx Co
Col B: No. of Shares
Col C: Date of investment (dd/mm/yyyy)
Col D: Amount paid
Col E: Date of Sale
Col F: Amount Received
Col G: Period held [using = Datedif(C,E)]
Col H: Gain/Loss [diff of Col D and Col F]
I want to highlight data as follows:
If Col G is > 12 months then Col H Green
If Col G is < 12 months then Col H Yellow
