Hi,
I try to register a formula (this is an extract)
when I record the macro with conditional formatting it works well, but the macro is not registered..
I am not still good in VBA, so I would like or to bypass the VBA finding a way to register the macro, or a really easy code like ( select ex A1, if A1< 105% A2 so tag as orange, if (instead) A1) is (even)< than 95% of A2 tag as orange, if A1<0 tag always as negative(stop if true)

sales
=$C$12<$D$12*(1,05) orange
=$C$12<(0,95)*D$12 red

profit
=$C$13<0 stop if true
=$C$13<$D$13*(1,05)
=$C$13<(0,95)*$D$13


Net worth

=$C$14<0 (stop if true)
=$C$14<$D$14*(1,05)
=$C$14<$D$14*(0,95)