How do I- IF the cell background is RED in color then contain 1

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

For example, IF the cell $C$9 has a background color of RED then I want to
display 1 in this cell ($D$9). Once this is completed I am tallying up
everything in column D to find out how many times that happened.

(FTI - reason for this is that RED shows an absence and we need to calculate
how many absenses)
 
Trust me on this!

It would be easier to denote an absence with an "A" and then count the As as
opposed to counting RED cells.

=COUNTIF(A1:A10,"A")

Biff
 
In addition.......if you really want the cell to be red use Conditional
Formatting to color it red after you enter Biff's "A" for absence.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Color background with Matching cells in row 6
How to change cell background color as part of the If statement? 2
change the color of cell background based on a result 2
Conditional Sum Based on Cell Background Color 6
Trying to change the background of a cell if I type a certain wor 3
Add values based on text color with the criteria of a date 7
What is the macro to change background based on numeric cell value 2
Cell background color update 2

Back
Top