This isn't security related per se, but I was hoping some of you programming geniuses out there might be able to help me out with the logic or syntax to accomplish what I need in Excel XP.

I have columns of data. I basically need to write a formula that will assess the entire column and return a true/ false.

For example- one column contains Y for yes and N for no. I need a formula to determine if all of the cells are Y. If any of the cells are N then the result of the formula should be false.

I also have a column of dates. I need a formula that will analyze each of the cells and if ANY of the cells have a date more than 1 year ago then the result of the formula should be false.

In the end, I need these summary cells for each column to be green for true and red for false. I was planning on simply returning true/false and manually filling the cell color based on the formula result, but if anyone knows how to automatically fill the cell color based on the formula result that would be helpful too.

TIA