Simple/Easy Conditional Formatting Question - except for me

[bmoore_namaste]

Greetings all from an Excel macro rookie!
I have what I think is a simple challenge:

I have an Excel macro that queries a database and returns about 20 columns/fields and an unknown number of records.

My challenge - after the dataset is returned, I then want to query the cell contents for a "Y" and color code accordingly. If the value is "Y", I wish the interior color to be green. If NOT "Y" then the interior cell color is green. i wish to repeat until the end of the dataset (until an empty cell is reached).

I am NOT a VB developer - so I'd ask that anyone who wishes to jump in be gentle with me. ;-)

thanks for any help,

b

[arlu1201]

You have one way of accomplishing this.

Keep a template file which has the conditional formatting already setup. Then copy-paste special values your dataset into this template. All the required fields will change their colors as per the formatting.