Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to create a circle (ie. color specific cells in a spreadsheet)
based on a certain diameter (ie. 100 cells). This could be code (formula) written in Visual Basic that would use the given diameter and automatically selects cells to leave out of the circle (different color). I was wondering if this is some way that has already been implemented previously or if there is a formula (circle equation I believe, R^2 = X^2 + Y^2) that I could use in VB and automatically apply it to spreadsheet cells and only color the cells that would form a circle and leave other cells as is? Your help is very much appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Draw a circle in Excel with the radius and center from the contents of cells | Charts and Charting in Excel | |||
Selecting cells of a specific color only. | Excel Discussion (Misc queries) | |||
clear specific cells in a form | Excel Discussion (Misc queries) | |||
How to draw a circle in excel with specific radius | Excel Worksheet Functions | |||
Sum formula of cells with specific color value | Excel Worksheet Functions |