Thread: How do I- IF the cell background is RED in color then contain 1
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sunshine19992 sunshine19992 is offline
external usenet poster
  
Posts: 1
Default How do I- IF the cell background is RED in color then contain 1
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)
Reply With QuoteReply With Quote