J
j5b9721
I do understand a little about the AND formula, but my problem goes deeper
then that from what I tried to do today. I hope you will be able to help me
solve this problem as it's becoming very complicated and taxing to me also.
If you have time I will appreciate your help. It seams that I may need in
Conditional Format a multi-situation in 2 Conditions.
I will go straight to the problem... you just may follow whats happening
with my
explination.
BZ CA CB CC CD
221 19 -65 74 --- line 4
-0.53% 1.78% -1.75% 5.89% --- line 6 Formula is
=IF(CC7="","",(CC7-CB7)/CB7)
is "CC6"
It needs CF "Condition 1" has a few given situations that are need.
Condition 1 needs... (red text & yellow fill)
CC6 to be between 0% and -4.9% "TRUE"
If CC6<-5%, BY6 ... CB6 and if any is >=CC6 "TRUE"
If CC6<-5%, Sum(BY6:CB6) must be >4.75% "TRUE"
If CC6<-5%, BY4 ... CB4 all must be <60 "TRUE"
I have tried some different ways to write this condition... but at times it
format the cell before I log a price in the cell.
Can you also help me with "Condition 2"???
I dont know if this is right...
=IF(CO7="","",AND(CO7>CF7,CF7>BY7)) I need to add more "True" logical
situations to this also... but where do I put them?
But I need to start with this =IF(CO7="","", to stop the formating early
like in the above Condition 1.
How do I add more logical situations to this???
Thanks for your time...
then that from what I tried to do today. I hope you will be able to help me
solve this problem as it's becoming very complicated and taxing to me also.
If you have time I will appreciate your help. It seams that I may need in
Conditional Format a multi-situation in 2 Conditions.
I will go straight to the problem... you just may follow whats happening
with my
explination.
BZ CA CB CC CD
221 19 -65 74 --- line 4
-0.53% 1.78% -1.75% 5.89% --- line 6 Formula is
=IF(CC7="","",(CC7-CB7)/CB7)
is "CC6"
It needs CF "Condition 1" has a few given situations that are need.
Condition 1 needs... (red text & yellow fill)
CC6 to be between 0% and -4.9% "TRUE"
If CC6<-5%, BY6 ... CB6 and if any is >=CC6 "TRUE"
If CC6<-5%, Sum(BY6:CB6) must be >4.75% "TRUE"
If CC6<-5%, BY4 ... CB4 all must be <60 "TRUE"
I have tried some different ways to write this condition... but at times it
format the cell before I log a price in the cell.
Can you also help me with "Condition 2"???
I dont know if this is right...
=IF(CO7="","",AND(CO7>CF7,CF7>BY7)) I need to add more "True" logical
situations to this also... but where do I put them?
But I need to start with this =IF(CO7="","", to stop the formating early
like in the above Condition 1.
How do I add more logical situations to this???
Thanks for your time...