I can't figure this out!!

[nismoz200]

Hi y'all

I was wondering if someone could help me out...
i have two columns of x-y data that has been entered and plotted out on a xy scatter plot. i was wondering if it is possible to write some kind of VBS to look at a group of cells, determine if any of the values is greater than 10, and then highlight that point on the scatter plot in red if it is less than 10 and green if it is greater than 10.

I've been trying to figure this out for a while...and i really can't seem to get it. If anyone knows how to do it, PLEASE let me know!!!
Thanks and appreciate the help.

 

[PaddyD]

Hi - welcome to the board!

You could consider transforming your data as below & plotting a,<=5 & .5 ratrher than a & b:

Book5
	A	B	C	D
1	A	B	<=5	>5
2	1	5	5	#N/A
3	2	2	2	#N/A
4	3	8	#N/A	8
5	4	1	1	#N/A
6	5	6	#N/A	6
7	3	8	#N/A	8
8	4	2	2	#N/A
9	5	8	#N/A	8
10	6	7	#N/A	7
Sheet1

paddy