pankajgrover
Board Regular
- Joined
- Oct 27, 2022
- Messages
- 99
- Office Version
- 365
- Platform
- Windows
Hi, i am doing copy paste formula according to buy sell option. But i want if cell have green color this Formula =(((F22-L22)*B22)*C22)-AI22+O22-N22 apply or if have red color this Formula =(((F21-L21)*B21)*C21)-H21+AI21 apply in same Net result column. Still now i doing manually and How i do that automatic? I want in below example AI column auto pick formula from cell AG16, AG17 color based .Should i do any conditional formatting ? Thanks
Shares Trading (1).xlsx | |||||||||
---|---|---|---|---|---|---|---|---|---|
AC | AD | AE | AF | AG | AI | ||||
15 | Net result | ||||||||
16 | Oil | 6621.00 | 23/12/2022 | 0.5 | 6500.00 | -6050 | |||
17 | Gas | 430.00 | 23/12/2022 | 1 | 410.00 | 25500 | |||
sheet |
Cell Formulas | ||
---|---|---|
Range | Formula | |
AI16 | AI16 | =(((F16-L16)*B16)*C16)-H16+AH16 |
AI17 | AI17 | =(((F17-L17)*B17)*C17)-AH17+O17-N17 |