white

Hi, Is it possible with Black & White printing in Excel to make specific cells still print in colour ??

Hi all, So I'm trying to run an INDEX MATCH against the nuber of visits that some of my web pages have received and view the top 10 by category. The issue I have is that I've found that some of the pages have received the same number of visits so when running the INDEX MATCH it's returning the...

All, I will use column A and B as the columns I want to change: I want to make column A Red if column A is not filled out but column B is filled out. But I want to leave column A White if Column B is not filled out. I have not been able to figure that out.

Has anyone ever used one of the options in the automation add-ins? Just wondering why they might be useful, is there anything useful in there or is it just another Excel white elephant

When I click the button if its WHITE it turns to RED if its RED it turns to WHITE the code operates correctly but when the color suppose to change back to WHITE it changes to a very very light Red, but there are times when it changes completely white. Is this just an Excel thing ??? I really...

Hello Everyone I am pulling a blank and need help. I want my if statement to do the following - If cell A11 = TRUE Return "BLACK" If cell B11 = TRUE Return "WHITE" IF...

Hi Everyone, Firstly just looking for ideas I can try out so if you think you can help let me know. I have a macro that runs great, its one that takes data one row at a time and finds were to put it on another sheet. I'm sure you know what I mean when I say it does the x = 1 to lastrow...

Hi All, I'm having a problem getting index/match to work with wild cards, and I haven't come across a solution to my particular issue. Here's a simplified version: <tbody> A B 1 Apples Fruit 2 Pears Fruit 3 Bananas Fruit 4 Grapes Fruit 5 Corn Veg 6 Beets Veg...

I have a macro that searches one of my sheets in excel, let's call the sheet "Keywords". After searching it returns the matches. The Keywords sheet has a bunch of terms like "dog", "small", "big dog", "small white dog", etc. The problem I am having, and wondering if there is a way to teach...

I use the code below to check the quality of a range of cells. If a quality is met I want the cell being checked to have a black background and white text. I can easily apply the code for a black background but I cant figure out how to add the property to have a white font. Do I need to repeat...

Hopefully I can explain properly, so here goes. In column A:C I have data in some cells while others are blank. <colgroup><col span="2"><col></colgroup><tbody> Red Q30 1 Blue 2 Green QX70 3 Yellow QX70 3 White FX50S 4 Purple Q50 5 Black FX35 6 Gray 6 White 6 Orange 6...

I would like to have a 6x6 range (eg: E3:J8) where some cells are filled black, and some are filled white ... I would, however, like each corner cell to have no choice but to be black. To produce multiples of these 6x6 ranges on the one A4 page, I could write a basic formula into each cell...

Need help with conditional formatting. I have the following: A1 = I'm using a List (Data Validation) with two values (Male; Female; or blank) A2 = Same List (Data validation) used in A1, the only difference that here I want to use Conditional Formatting highlighting when the values between A1...

I have two tabs, lets call them White and Black. In White I will record data, I.E cell A1 is a name, Chris. cell B1 is a number, 200. cell A2 is Jen. cell B2 is 300 In my Black tab I have the same column A, Chris, Jen, etc. But column B i need it to pull directly from Chris’s or Jen’s...

I have a PowerPoint where the background is blue (I cannot change). In order to make the information stand out, I have the excel information in white - however, I can't see if unless I color the excel background. How do I keep the excel font white so that it shows in the PPT? is there a way...

Range("B4:F4").Select With Selection .Interior.ColorIndex = 1 .Font.Name = "Calibri" .Font.Size = 12 .Font.ColorIndex = 0 End With Hello All, I'm trying to write a simple code that will turn range B4:F4 Fill to Black, but the font to white, so it will show in the black field. I'm having...

I'm creating a video game that uses an 8 by 8 grid. I need half of the 64 cells to be black and half white. I'm using conditional formatting to highlight the cells white or black. I've got a randomizer to randomly make the cells either black or white. But, I can't figure out a way so that - no...

Hello, simple one :) if color of any cell in range lastRow col A, columns A:P is not white than color every white cells in this row in this range to RGB(157,157,157). I'd like to color every white cell from column A to column P to grey but do not touch red colored cells only if red...

Hello, I am looking VBA solution, which can fill the colours if lower line data match with upper line using alternate colourers For example: Row3 data match with row2 fill colour red and font white Row4 data match with row3 fill colour green and font white I am using conditional format...

Hello Everyone, I was hoping someone could help me with a formula for a similar situation to what I have below. I know I can use an index/match formula to match B2 to column A and pull "The Snow is white". But I can not seem to find a way to do it the other way around. <tbody> A B C 1...