Link to home
Start Free TrialLog in
Avatar of vsuripeddi
vsuripeddi

asked on

conditionally formatting a picture on Excel Sheet

I am using Excel 2007.
I am having a picture on the column D of my Excel Sheet.

However this picture should be visible only if the cells A1 to A10 are all filled with values.
If there are no values in any of the cells, the picture should not appear.
If all the values from A1 to A10 are there, then it should appear.

Is there any way, I can do it with conditional formatting or any other means. I do not require macros or VBA code. For security purpose all macros are disabled.

Please suggest a method.
Avatar of vsuripeddi
vsuripeddi

ASKER

Please suggest me a remedy
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I've requested that this question be deleted for the following reason:

No suitable remedy suggested
Not possible is an "Answer" which will be part of the EE knowledgebase and deserves full marks.