Hi all,

I would like to conditionally format a report in the following manner:

Applying a set of rules, I would like to "circle" (an ellipse might be more accurate) selected data items.

In the example below, I have used Excel for the report and have highlighted two data items.



The macro which produces such ellipses looks like that below (this is an example only and doesn't relate to either ellipse in the above example):



I can get values for the Excel constants easily enough but is there a reliable way of placing the ellipses in precisely the right spot or is it just a matter of doing it and then fiddling?

It would be nice if I could say something like:

oExcel.Cell(2,3).Ellipse(.....,.....)

Alternatively, I might be able to place the ellipse in the correct spot if I can I get the .Top, .Left, .Height and .Width values for a given cell programatically. Is that possible?

Does anyone have any suggestions here? I'm not wedded to Excel either. I assume I could do the same with Word but would have similar placement problems.

Finally, is this stuff possible in less sophisticated applications such as Wordpad and Notepad?

Thanks,

Russell.