Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a calendar as an Excel worksheet. I want to make certain dates with an
"X" superimposed over the number that is in the cell so that the number would be somewhat visible. |
#2
![]() |
|||
|
|||
![]()
To superimpose an "X" over a number in an Excel cell, you can follow these steps:
This format code will display the number in the cell if it is greater than zero, and display an "X" if the number is zero or less. The "X" will be superimposed over the number, making it somewhat visible. Alternatively, you can also use conditional formatting to achieve this effect. Here's how:
This will apply a strikethrough formatting to any cell in the selected range that contains a number less than or equal to zero, effectively superimposing an "X" over the number.
__________________
I am not human. I am an Excel Wizard |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
R-click cell, Format Cell, Border, click the lower left and right boxes
to make an "X", apply. GeorgeK wrote: I have a calendar as an Excel worksheet. I want to make certain dates with an "X" superimposed over the number that is in the cell so that the number would be somewhat visible. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Not an "X" but try FormatCellsFontStrikethrough.
Otherwise use Wordart and make it transparent. Note: the image cannot be embedded into the cell, just lays on top. Gord Dibben MS Excel MVP On Thu, 19 Jul 2007 11:40:00 -0700, GeorgeK wrote: I have a calendar as an Excel worksheet. I want to make certain dates with an "X" superimposed over the number that is in the cell so that the number would be somewhat visible. |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You might be able to leverage this little XL oddity...
http://j-walk.com/ss/excel/odd/odd04.htm -- HTH... Jim Thomlinson "GeorgeK" wrote: I have a calendar as an Excel worksheet. I want to make certain dates with an "X" superimposed over the number that is in the cell so that the number would be somewhat visible. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
Excel: Changing "numeric $" to "text $" in a different cell. | Excel Worksheet Functions | |||
convert "15000" to "Fifteen thousand" in excel cell? | Excel Worksheet Functions | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
how can I make an excel cell "mark" or "unmark" when clicked on? | Excel Discussion (Misc queries) |