Forum Discussion
Excel, how to add a coloured cell as only "1" and ignore the cell value, w/ multiple colours?
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...
See the attached workbook.
Hey, my bad for not mentioning, i am also using google spreadsheets, and there is no fraction formatting (that i am aware of anyway) so the result stays as (0.40 instead of 4/10).