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

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?

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 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.

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

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 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?

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.

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

Dear All,

Suppose in a workbook I have more than 1 sheets. Few cells of each sheet are multicolored for different values.

Now In particular sheet I want the sum of all the colored cells in all sheets:

Suppose:
Sum Of Green colored cells:
Sum Of Yellow colored cells:
Sum Of Pink colored cells :
& so on..............

Is it possible using a VBA code ?

Thanks in advance

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: