macro not register my conditional format formula

C

collinskyyou

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Sum 2
My macro doesn't work if sheet is protected but it works if not protected 2
Conditional format 2
Error with calling Format sub 7
Returning a Date with Multiple Criteria Lookup Values 0
Macro to delete row if cells greater than certain value 1
Excel 2007 VBA: Convert laaaaarge number to Hex 31
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3

Top