Hello!
I'm looking for a solution to my problem, which is - when a cell value (number) is greater than 0, I want a picture A shown, but when the value is less than 0, I want picture B shown.
If that is not possible, I want all cells in the worksheet to be light green when the value is greater than 0 and red, when the value is less than 0.
Looking forward to your answers! Thank you in advance!
Hi Artiso and welcome to the forum,
The second part of you question (no pictures and simply green or red) is very easy using Conditional Formatting.
see http://ulearnoffice.com/excel2010/ex...formatting.htm
A sample workbook with two pictures might be needed to test the first part of your question.,
One test is worth a thousand opinions.
Click the * below to say thanks.
have a look here http://www.excelforum.com/excel-gene...ell-value.html
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks