Forum Discussion
Solved
Excel, how to add/detect a coloured cell as only number "1" and ignore the cell value
Hey, ive got a attendance report with up to 10 weeks per person. Right now i have 2 sepertae formulas, 1 which uses cell value to determine colour (so 1=red (absent), 2=green (present) etc.) And anot...
ApexSurv1vor It's not entirely clear how your data is setup, but the COUNTIF function might work. For example:
=COUNTIF(range, 2) & "/10" =COUNTIF(B2:K2, 2) & "/" & COLUMNS($B$1:$K$1)COUNTIF Example
Please see the attached sample workbook, if needed...
ApexSurv1vor It's not entirely clear how your data is setup, but the COUNTIF function might work. For example:
=COUNTIF(range, 2) & "/10"
=COUNTIF(B2:K2, 2) & "/" & COLUMNS($B$1:$K$1)
COUNTIF Example
Please see the attached sample workbook, if needed...
Yes that is exactly what i was looking for thankyou so much!