conditionally formatting a picture on Excel Sheet

[dasiga444]

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.

 

[PHV]

I do not require macros or VBA code
So, why ask in a VBA forum ?
I'd post here:
forum68

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

hi,
"Is there any way, I can do it with conditional formatting"

This cannot be done with native Excel Conditional Formatting, as what you want to do is not a FORMAT feature. Rather it relates to the Visible Property of a Shape Object.

"or any other means."

Yes, it can be done with VBA code

"I do not require macros or VBA code. For security purpose all macros are disabled."

Well, you may not "require" VBA code, but in order to accomplish this requirement, VBA code IS required.






Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]