Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
returning either a shaded cell &/or a text
is there a way excel can return a shade in a cell along with a message?
Example: cell a3:a8 sum up to 0. Can cell a10 return Yellow shade and the words "No Work"? Thanks in advance, D_Kight |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
returning either a shaded cell &/or a text
In A10, you could use:
=if(sum(a3:a8)=0,"No work",sum(a3:a8)) And use Format|conditional formatting to show the color. Cell Value is Equal to ="No Work" ====== Another option that keeps the value as a number: Give A10 a custom format of: General;-General;"No Work" Then use cell value is equal to 0 By keeping the value as 0, you'll be able to do other arithmetic using that cell. Another option: d_kight wrote: is there a way excel can return a shade in a cell along with a message? Example: cell a3:a8 sum up to 0. Can cell a10 return Yellow shade and the words "No Work"? Thanks in advance, D_Kight -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I paste text data into ONE cell only? | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
HOW TO KEEP TEXT FROM MOVING OUT OF A CELL? | Excel Discussion (Misc queries) | |||
How do I set text to top of cell next to wrap text in Excel? | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions |