Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a "number of days of sick" column on my spreadsheet, and i would like
to know if theres a function that could fill the cells with a colour when that certain person has reached a certain number of days of sick? e.g. cell turns read when it hits 10 onwards. Thankyou |
#2
![]() |
|||
|
|||
![]()
Chris, you can use conditional formatting, select the cell you want to
change color then format conditional formatting, cell valve is, greater than or equal to 10 and pick red for your pattern -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Chris01623" wrote in message ... I have a "number of days of sick" column on my spreadsheet, and i would like to know if theres a function that could fill the cells with a colour when that certain person has reached a certain number of days of sick? e.g. cell turns read when it hits 10 onwards. Thankyou |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Turn off cursor from automatically highlighting cells in Excel? | Excel Worksheet Functions | |||
update row numbers after different active cells in macros followi. | Excel Discussion (Misc queries) | |||
highlighting cells which have dates later than... | Excel Discussion (Misc queries) | |||
Converting negative numbers in a range of cells to zero | Excel Discussion (Misc queries) | |||
combining several individual cells of numbers into one cell | Excel Worksheet Functions |