This might sound easy - but not…
I have one cell that is showing results from two different calculation…
So if result is comming from one calculation - that result is showed - and comming from the other calculation showing that result… (could also show both at the same time - but dont need).
Before I made this I only had a single cell with one calculation - and my condition formating was - that if the result was more than 0 change background color to green.
Worked fine…
However that dont work - when I am using two calculation with result in same cell.
This code is in the cell that showes the results.
=HVIS(B8="";"";B4+B5) &" "& HVIS (D8="";"";D4+D5)
How can a make a condition or a makro that will change background til green if either of the above is more that 0
Thanks in advance.
kim
(LeroyG added Preformatted text to the formula)