Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell Format
I am editing a spreadsheet which the original user used cell formatting to
indicate postives. It looks very pretty!! Is there a function I can use,as it contains over 3000 row, to replace the shaded (filled but blank) cells with yes? |
#2
|
|||
|
|||
See one potential answer in .misc.
Please don't post the same message in multiple groups. It tends to fragment any answers you give, and potentially wastes the time of those providing a solution that has already been given. See http://cpearson.com/excel/newposte.htm for tips on using these groups effectively. In article , gb_S49 wrote: I am editing a spreadsheet which the original user used cell formatting to indicate postives. It looks very pretty!! Is there a function I can use,as it contains over 3000 row, to replace the shaded (filled but blank) cells with yes? |
#3
|
|||
|
|||
Thanks for replyng and the user prompt. where do i find .misc. The only
forums i can find is charting, datamap etc. "gb_S49" wrote: I am editing a spreadsheet which the original user used cell formatting to indicate postives. It looks very pretty!! Is there a function I can use,as it contains over 3000 row, to replace the shaded (filled but blank) cells with yes? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format a cell with numbers and user defined text | Excel Discussion (Misc queries) | |||
Custom format that shows blank cell if another cell is empty | Excel Discussion (Misc queries) | |||
format cell for figures - Ajit | Excel Discussion (Misc queries) | |||
Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
How do I unhide the cell format function in Excel 2000 | Excel Worksheet Functions |