How I can do an excellent formula that omits Shaddad cells? is for college football games?

They gave me a sheet calculation for college football games, and when the winner is selected, people who received the wrong game to get their beaks shaded How I can make a total points column is omitted in black boxes? shaded basically be equal to 0 and no shadow would equal1 ????? by Please help!

No Alt-F11 and paste this piece of code in a module: - Function Xcolor (Target As Range) As Integer End Xcolor = Target.Interior.ColorIndex Function Function Ycolor (Target As Range) As Integer = Ycolor target.Font.ColorIndex Zcolor End Function Function (target As Range) As Integer = Zcolor target.Borders.ColorIndex ___________________________________________________ End Function You can now use color reference numbers in formulas. The white / clear is -4142. So the formula would be: - = IF (XCOLOR (A1) =- 4142,1,0) Drag the formula up and down the entire column, then the SUM bottom.

Crabtree's Top 5 Fresh Facts

Tagged with: • • • •

Filed under: College football

Like this post? Subscribe to my RSS feed and get loads more!