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 * Add Reputation 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 now happily retired
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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks