I need help, I have to calculate a spreadsheet in excel, each cell in each different column has a different co?

Question

I need help, I have to calculate a spreadsheet in excel, each cell in each different column has a different color background, I have to compare each column one to another; how can I do that, having only as reference the background color?

Answer 1

Copy/paste these three functions into a module of your workbook (Alt-F11).



Function Xcolor(target As Range) As Integer

Xcolor = target.Interior.ColorIndex

End Function



Function Ycolor(target As Range) As Integer

Ycolor = target.Font.ColorIndex

End Function



Function Zcolor(target As Range) As Integer

Zcolor = target.Borders.ColorIndex

End Function



You can now use XCOLOR() to determine whether two cells have the same background color.

For instance

=XCOLOR(A1)=XCOLOR(B1)

will return "TRUE" if both cells are the same fill color. The other two functions refer to the font color and the border color.

Answer 2

The only way to 'calculate a spreadsheet by cell color' is to do it with a macro. Your actual goal is a little unclear, however. Is each column a separate color, with each cell in the column the same color? Or, is each column comprised of cells of differing colors?

Answer 3

If you are using Office 2007, you can filter the data by using colours:



Apply the filter, under the Data option on the ribbon.



Use the drop down box at the heading of the column you wish to sort, then select 'Filter by Colour', and then choose your required colour.

You are able to perform this filter option on multiple columns if required.



Hope this helps...

Answer 4

you decide on guy or woman countif purposes, so on the backside of your checklist i might advise entering into separate cells the O, A, G and C and alongside the function =countif(A3:A50,"O"). that's assuming your data is in cells a2-a50. in case you bypass as much as the formulation bar once you have carried out this function and only press the F4 function key, this might make your reference absolute so which you will reflect all of it the way down to cover the A, G and C and then substitute the letter contained in the final area of the function for one and all.