Formula depending on the color of a cell to calculate values

[keranali]

Good Day All can I calculate values based on the colors of a cell. Calculation will be.... For Cell BJ3....if BF3 is red then take BI3 and make it a negative value and For Cell BJ3... If BF3 is Green then take (BM2*BL2)-BI4

Cell Colours

the project 1.3.xlsm
	BF
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
Overview

Sample output

the project 1.3.xlsm
	BI	BJ
2	Investment	Profit/Loss
3	$ 110.00	$ (110.00)
4	$ 110.00	$ 60.00
5	$ 110.00
6	$ 110.00
7	$ 110.00
8	$ 110.00
9	$ 110.00
10	$ 110.00
11	$ 110.00
12	$ 110.00
13	$ 110.00
14	$ 110.00
15	$ 110.00
16	$ 110.00
17	$ 110.00
18	$ 110.00
19	$ 110.00
20	$ 110.00
21	$ 110.00
22	$ 110.00
23	$ 110.00
24	$ 110.00
25	$ 110.00
26	$ 110.00
27	$ 110.00
Overview

Cell Formulas
Range	Formula
BJ3	BJ3	=-BI3
BJ4	BJ4	=(BM2*BL2)-BI4
BI3:BI27	BI3	=$BM$2*$BN$2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
BH3:BI28	Expression	=AND(BG3<>"",ISEVEN(BG3))	text	NO
BH3:BI28	Expression	=ISODD(BG3)	text	NO

Adjustable values

the project 1.3.xlsm
	BL	BM	BN
2	34	5	22
Overview

 

[keranali]

Thanks so much for taking the time to address this problem I have downloaded the file and will implement andreport back.

 

[keranali]

The formula worked perfect thanks so much for this I saw the problem in my formula with the $signs and corrected them. Thanks again

 

[etaf]

you are welcome