Email:      Pass:    Pass?
Advertisements


Free Excel Forum

Colored Cells Are Showing White On Screen, Want To See Color?

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

I have sheet cells that I know are colored, but they show white on my system,
and print grayscale, while showing their true colors on other office
systems....



Similar Excel Video Tutorials

Helpful Excel Macros

Automatically Highlight the Active or Selected Cell
- This macro will highlight the active cell in any excel spreadsheet with a color selected in the code. This means that a
Determine a Cell's Color with this UDF - Outputs as Text or the Index Number in Excel
- This free Excel UDF allows you to output the color of a cell in text format or as that color's index number. Also note
Print Preview Screen Display for The Current or Selected Worksheets in Excel
- This free Excel macro allows you to display the print preview screen or window for the current or selected worksheets in
Highlight the Row of the Selected Cell
- This macro will highlight the row and column of the active cell. This will fill the row of the active cell with a solid
Highlight the Row and Column of the Selected Cell
- This macro will highlight the row and column of the active cell. This will fill the column and row of the active cell w

Similar Topics







Dear All,

I have a strange problem with Excel. Colored fonts, fills and borders will not show on screen, even though I know how to do this. All text remains black and cells remain white. My screen is OK, because colors & fills show up OK in other applications (such as Word), and they also show OK in "print preview" mode, and also when I print. It's only on the main Excel screen that the colors do not appear. Opening the same file in another computer shows up the colors fine. Is there some obscure Excel setting that is causing this behaviour? What do you think?

Many thanks everyone ...


Experts:

I have a large worksheet that was initially created by selecting the entire worksheet (Ctrl A) & then Fill Color White. This removed all the gridlines. From there, the user filled in the worksheet with data, formulas, etc. & also highlighted certain cells various colors.

I would like to remove all the white shading, but keep all the non-white shading in place. This would show all gridlines except cells that are fill colored.

I know I could spend time by going through the entire thing and eye-balling for non-white fill colored cells, but I was hoping that there might be a quicker way. I tried to do this via conditional formatting, but no dice there. Was wondering if anyone here had any advice. Please note that I can't use VBA.

Thanks.


In print preview, and on printed pages, all colored font shows up as black.
White font stays white. Font colors are displayed correctly in the worksheet.

I have already tried the following:
-> uncheck "black and white" in page setup
-> change printer resolution, etc.
-> creating a new workbook, typing some sample text and changing the color:
the problem is not confined to one workbook.
-> gray cell shading prints as gray: the problem is confined to fonts.
-> colored font in Word previews and prints as displayed: the problem is
confined to Excel.
-> Excel help files, online help, etc.

Thanks in advance for any help.



Hi All,

Can anyone tell me the VB script where i can lock all cells which are not colored? or colored in white.

Doing that users who will use files can only change colored cells (say yellow & green)

Regards

Deepak Sharma


I know that:
Code:

.PageSetup
.BlackAndWhite = True


Will print in black and white but if I have a box with a gray background it will only print it as white.

Is there a grayscale option so when I print a box with a gray fill it comes out as gray not white?


I have several cells color-coded (based on frequency) but there are many white, non-colored, cells which I need to color gray.

Is there any way to color all these non-colored cells quickly, as I have many sheets to do.

Seems like an easy logic I just cant find a simple way to do it.


Hello Everybody,

I am using Microsoft Excel 2003.

I put color in my cells to show contrast with the information in my data list. I used blue and white for my cell colors. When I used sort to put my information in alphabetical order it did not only rearrange the information, it also rearranged the colored cells. My orginal pattern (before using sort) was blue, white, blue, white, blue, white. After I used sort, the pattern was changed to white, white, blue, white, blue, blue.

Is there any way I can use sort to arrange my information only in alphabetical order, using sort, without rearranging the color of the cells?

If anybody knows, please answer and thank you in advance.


Hello,
I have the attached spreadsheet. It is used for attendance. People color code the cells when someone is not available, different colors mean different things.
With the help of this form I managed to come up with a formula that checks each cell to see if it is white, and if it is it sums it. I now get a total number of People working based on how many white cells there are in the range for that day. Brilliant!
I now want to take it one step further, if possible. I would like to be able to make a LIST OF NAMES of who is working each day. So I need to be able to search by date, for white colored cells, and then populate the name based on date / white cell.

Is this possible?
Thanks,
Todd


Is there anyway I can hard-code the color of each row?

Id like to alternate white with tan (office 2003) if possible.

The shared workbook we use now is colored manually. When pasting, the formats paste as well and I wonder if hard coding it will prevent the format from being pasted. I DO realize you can paste special, but I am not going to put in the time to show that to the employees using the workbook since I could just go back to an all WHITE workbook.

Thanks


I am making an electronic timsheet I am designing more pleasing to the eye by color coding everything that is locked in a light blue, and everything that the user must fill out in white. After the timesheet has been completed for the pay cycle, it is printed and signed.

Is there anyway to tell the spreadsheet to only show color on the electronic version? That is to say, when it is printed, all cells should be completely devoid of color, as it is printed in B/W on colored paper (blue paper for union employees and pink paper for supervisors). Right now, the shaded cells appear "grey" when I print it in B/W on the colored paper.

Thank you in advance if you are able to help!




Hello,

I have a matrix of cells that is located between A1 to Ao44.

There are cells of 4 colors and some of the borders painted in green.

I would like to know the total count of each colored cell.
(Don't care for the border)

Is it possible to have a live count of colored cells?
Total for each type?

I am still new to macros and execution of them.
Please include a how to run proceadure with it too.


Also, is there anyway to know what is the value of the colors that I selected to fill cells?


Regards,
Harry


Here's my task.
I have a table. Big, big table. Rows are filled with info and numbers. I have 4 different kinds of info that I will color-code (using either different colored text or interior cell color, doesn't matter).

I will copy-paste a bunch of data into one spreadsheet. First the white data, then the red data, then the blue data, then the yellow data. I will then sort the data in the entire spreadsheet based on a numerical value in a certain column.

The first (empty) column (A) will need to have a simple calculation B2-C1, B3-C2, on down the line, with the sum appearing in cell A2, A3, etc.

I will do this spreadsheet manipulation on different days. The colored info will change from day to day. The white info is the reference info and will not change. I would like to set up a macro or VBA to automate this, but I don't know how to get started.

Here's the Tricky Part (FigNewton): the calculation that I need depends upon the color of the cell in Column C. It must be white--the reference data. So if there are 3 colored rows below a white C cell, the calculations should be B5-C4, B6-C4, B7-C4 with the solutions appearing in A5,A6 and A7 respectively. Because the table is sorted, all the different colors are intercalated, and there is no real pattern. I can do the same macro three times for the three different colors--would beat doing the corrections row-by-row.


I just got the 2011 version on a new iMac. The macros work fine, except I cannot record a macro on my iMac or run a recorded macro made from another version, for unknown reasons.


Any help greatly appreciated.


hi

I have a small problem.Can anybody please help me.

Please see the attachement to follow the problem.

Here for example in column D4,the entries are NST and STD

1)So i want it such that if first cell is NST, and 2nd cell is also NST and so on then the current cell(NST) which is same as the previous cell value
should be colored in WHITE using only Conditional Formatting and No macros.

So in the output(2nd screenshot) the 1st cell is NST and all other cells below that are in WHITE as it is same to its previous cell value hence they are in white.


2)Similarly I want it such that if first cell is STD, and 2nd cell is also STd and so on then the current cell(STd) which is same as the previous cell
should be colored in WHITE using only Conditional Formatting and No macros.

So in the output the 1st cell is STD and all other cells below that are in WHITE as it is same to its previous cell value hence they are in WHITE.

The Conditional Formatting for NST and STD cases should be dynamic,should be applied for whole(entire) column.


Thank You.


hi
I'm posting this as a separate thread because it is different than my previous question, although it will indirectly solve my previous problem!

I have a small problem.Can anybody please help me.

Please see the attachement to follow the problem.

Here for example in column D4,the entries are NST and STD

1)So i want it such that if first cell is NST, and 2nd cell is also NST and so on then the current cell(NST) which is same as the previous cell value
should be colored in WHITE using only Conditional Formatting and No macros.

So in the output(2nd screenshot) the 1st cell is NST and all other cells below that are in WHITE as it is same to its previous cell value hence they are in white.


2)Similarly I want it such that if first cell is STD, and 2nd cell is also STd and so on then the current cell(STd) which is same as the previous cell
should be colored in WHITE using only Conditional Formatting and No macros.

So in the output the 1st cell is STD and all other cells below that are in WHITE as it is same to its previous cell value hence they are in WHITE.

The Conditional Formatting for NST and STD cases should be dynamic,should be applied for whole(entire) column.


Thank You.


Hi experts,

I have recorded a macro to print excel worksheets in color by unchecking print in garyscale option but its not working. Recorded code is as follows,

Application.ActivePrinter = ".......PRI_LC01 on Ne01:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1


this code prints in black white, but the code should go to the properties and color and uncheck "print in grayscale" under color options and then finally print in color

Could you pls help

Regards

Prabhu


Hi to everyone !

I am new here and I have a question / problem:

I want to have colored cells as much as I entered number value in one specific cell.

E.g.

In one cell (e.g. A1) I enter the number 10 and I want to have 10 colored cells in (same or other) row or column. (color or direction is not important)

1 - one colored cell
5 - five colored cells
25 - 25 colored cells
etc...

How can I do that in Excel?

Thanks.


When I send an excel spreadsheet to a coworker, he cannot see color in color
formatted cells. If there is a section of cells that is supposed to be black
with white writing, he will see nothing in these cells because his excel sees
the white writing, but does not make the cells black (White writing on White
background). I looked in the help section and could not find anything.



My co-workers and I print to a Xerox WorkCentre 7655 xerox/printer. We use Excel 2007.

For three of us, when we format our text to a color the text will not print in color but prints only in black. My other two co-workers CAN print their text in color.

When we print we are setting up our printer properties to print in color, spreadsheet is set up with "print in black and white" turned off, etc.

One other point, we have another color printer in the office which we CAN print text in color on. So the problem appears to be the "connection" between us three users and the Xerox WorkCentre.

Any thoughts as to where to look for the fix? Is it something inside Excel or is it a problem with the operating system or is it a problem on the Xerox end?

Thanks


I have a data entry form with colors. I want it to print black and white on print. There will be multiple users using the file so I need some kind of print macro or setting to print black and white? Thank you.


i use a module for summing up cells that are not white (colored)

it works but when i change the one of the cells' color the function wont update/

only after I change one of the colored cells' value' the function updates...


what can I do?


Can someone please help me. I am building a spread sheet and I have individual cells that I have colored different colors. The only way I can see If I have colored them properly is to do A print preview. In normal view I cannot see any colors in any cells. How do I change this so I can see colors of the cells in normal view?


Hi i have sheet few cells are coloured and few are non-colored i want to sort by color so that i can get the colored one side and non colored one side.

Through excel formulas or VBA macros


Yes Yes Electronics City Yes Yes Off Mysore Road Jeevan Bhima Nagar Yes White Field Road Yes Bhais Bhavan Road Itpl White Field Yes Infantry Road Yes yes BTM I Stage Dollar Scheme yes Whitefield Bommasandra Bannerghatta Road 3rd Block Jayanagar The Sirius Millers Road yes No - 7 Whitefield Main Road Yes Koramangala Yes Whitefield Industrial Area Yes 7- Whitefield Main Road Yes Varthur Hubli Yes Austin Tomb Yes Yes Off Intermediate Ring Road,Domlur Yes Yes Hosur Road Yes Ulsoor Road Hosur Road Yes M G Road Yes Kundalahalli 7- Whitefield Main Road Hal 2nd Stage Indira Nagar No 83 Infantry Road


Hi Guys,

What I am looking to do is search through and find any cells in Range A:A and if they are colored red (manually, no conditional formatting) I would like the same Row of column C to be colored red also.
For example if A1 is colored red then color C1 red

Any ideas?

Thanks


Is there a way to force a sheet to print out in black and white without changing the sheet itself to black and white. I was thinking of something that physically tells the printer to print in black and white vs. color.

My thing is that I have a lease copier that charges me a ton for color copies and the users of my workbook always forget to change the print properties to black and white.

I already tried the following script with no luck:

Code:

Sub PrintBnW()
With ActiveDocument
.Compatibility(wdPrintColBlack) = True
.PrintOut
.Compatibility(wdPrintColBlack) = False
End With
End Sub





Gday, earlier i posted a thread which may have been hard to understand. I figured it might be easier to just request a function if possible. ^^

In the image below i was hoping for a function that i could put into every cell from E5 to AD5 that would check if that cell is colored purple, then it would check if the cell to the left and right is colored white (of the default white color).

(ideally i want to be able to use this function for other rows too.)

I can probably finish it up with my limited knowledge from there. ^^

Image: