Fast Solution to Error: Can formulas take into account the color of the cell on the spreadsheet?

Can formulas take into account the color of the cell on the spreadsheet?

I have a spreadsheet with each cell representing a single day.  Some of the cells are highlighted YELLOW and that signifies a package is late.  I need to count the total number of packages (rows) and then the total number of days late (yellow highlighted
cells).  Is there a way to count a cell based on the highlight color?

Anwsers to the Problem Can formulas take into account the color of the cell on the spreadsheet?

Download Error Fixer (Free)

You can't do it with a simple formula.
You need to use some VBA code.
The function below will return the count of cells in InRange that have a background color equal to ColorIndex.
 
Function CountByColor(InRange As Range, ColorIndex As Long) As Long
    Dim R As Range
    Dim N As Long
    For Each R In InRange.Cells
        If R.Interior.ColorIndex = ColorIndex Then
            N = N + 1
        End If
    Next R
    CountByColor = N
End Function
You can then call this from a worksheet cell with a function like the following.
 
=CountByColor(A1:A100,3)
 
If you are new to code and don't know what to do with it, see
http://www.cpearson.com/excel/WhereToPutTheCode.aspx .

 
For much more information about colors in Excel, see
http://www.cpearson.com/excel/colors.aspx

In this method we will try to Boot in Safe mode with Networking and see if the error still persists.

  • Search "MSCONFIG" and Open.
  • Click on Boot Tab
  • Tick Safe Boot in Boot Option
  • Select Network.
  • Click Apply and OK.
  • Reboot your System.

Another Safe way to Fix the Problem: Can formulas take into account the color of the cell on the spreadsheet?:

How to Fix Can formulas take into account the color of the cell on the spreadsheet? with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system.  Open it, and it will perform a scan for your system. The junk files will be shown in the list.

2. After the scan is finished, you can see the errors and problems which need to be fixed.

3. When the Fixing part is finished, your computer has been speeded up and the errors have been fixed


Related: How to Update ASUS Xonar D2X driver for Windows XP 32/64-bit,Update ATI VGA Driver version 6.13.10.5779,How to Download Chicony Camera Driver version 61.005.029.1900,Download OKI C9800(PCL),How to Update TI Card Reader Driver version 2.0.0.10,Method to Download Toshiba Portege R835-P83 eco Utility v.1.3.21.0 driver,Method to Download Toshiba Satellite A660-BT2N23 Face Recognition v.3.1.3 driver,Download Toshiba Satellite L355-S7907 Face Recognition v.2.0.17.32 driver,[Solved] Download Toshiba Satellite L740-BT4N11 PC Health Monitor Utility v.1.7.9.64 driver,How to Download Toshiba Satellite P305D-S8828 WPS Library v.1.0.0.7 driver,Best Way to Download NVidia GeForce 6100 VGA Driver v.304.51 Certified,How Can You Update & Download NVidia GeForce 9300/nForce 730i VGA Driver v.310.19 Certified,Method to Download NVidia GeForce GT 330M Driver v.340.65,How Can I Update & Download NVidia GeForce GTX 590 Driver v.280.26 WHQL,Method to Download NVidia Tesla C2050 Driver v.319.17
Read More: Troubleshooting:Calculating\/recording the last date\/time a cell was changed,Solution to Error: camara de fotos no me aparece la barra de herramientas cuando quiero usar el libro digital,Troubleshoot:Can Flight Simulator 98 run on Windows 7? Error,Solution to Problem: Camera Objects often disappearing from a worksheet,How to Fix Error - Can a message box or the text in a message box change color based on a calculated value??,BSOD after upgraded to Windows 8.1 (memory problem?),Blurry programs on Windows 8.1,C:\Window|Microsoft.Net\Framework\v4.0.30319\mscoreei.dll could not be loaded,Browsing history is no longer visible,Bulk deleting from email deleted items folder
[PR]
by explorerwindows | 2016-08-26 15:18