cell color change

Hello, I am using the following code (which works great) to export the sheets named "Labor BOE xxxx" after my spreadsheet creates multiple copies of a template worksheet, inserts summary tables, and populates the summary tables. The one issue that I haven't been able to figure out is... after...

Hi I am working on a code in which i have to change the color of certain cells if the value of a cell is Y/N. The color should change with the user input. Set wsheet = wbook.Worksheets("XYZ") For Row_start=10 to Row_count 'Row count is the last used row in the worksheet RowValue =...

Hi I am working on a code in which i have to change the color of certain cells if the value of a cell is Y/N. The color should change with the user input. Set wsheet = wbook.Worksheets("XYZ") For Row_start=10 to Row_count 'Row count is the last used row in the worksheet RowValue =...

I have a spreadsheet that has conditional formatting where I track insurance expiration dates. If the cell is blank it is yellow If the date in the cell is current it is blank If the date in the cell expires within 30 days it is orange If the date in the cell is expired now it is red Now...

Hi all, let's see who can help me with this next excel vba question: I have a list that consists of several names (text or number strings - representing names and codes, usually 1-20 different strings), some repeating only once, and some several times. I'd like to sort by name (easy) and to...

how can i say if A1 is more than 100 then make the cell color red. and if A1 is less than 0 then make the cell color green. Also can i make A1 turn red only if A2 is more than 100 AND A3 is between 80 and 100? Help is much appreciated

Hi experts, Wondering if someone know how to Highlight a cell if value is >130% from another cell e.g. if cell B10 is greater than C10 by 130% (or custom % value) requred is if value in C10 = 10 and B10 = 13 then B10 should turn green if 15 yellow and if >18 red regards,

Hello there, It may sound silly but in my ciecumstances it will ease my work. If I enter a value in certain cell A2 to CK2 the color of cell may turn to Red as it would be alert activity. Experts know well how to do it.:rolleyes: regards,

A B C D 1 Name 2009 2010 Total 2 Sam 400 600 1000 3 John 200 400 600 4 Eric 100 300 400 I'm working on a simple list, see example above, where a cells background color changes (in a simple traffic light system) in both the Total (column D) and Name (column A) when the...

I have a annual meeting calender. In this calender different meetings are booked in different colors. (eg. sales, marketing, HR, Finance) For every department meeting is booked in every month. To view only one meeting at a time on click a have this formula. This formula works fine but it...

Problem: I have a few contiguous cells (below each other in same column) that are shaded (fill color). When I enter text/data/whatever in the next cell down and hit [ENTER], the cell I just entered text/data/whatever into automatically shades to the same color as the few cells above. I want to...

A colleague of mine has an Excel file where the font sizes and background cell colours of individual cells sometimes appear to have changed spontaneously when she re-opens the document. She had formatted the columns to different colours to indicate what they were being used for (various types...

I have a list of food products on several sheets. In one column are all of the expiration dates. I have conditional formatting to change the cell color to a different color depending on if its expiring this month, next week, this week, or in the last 7 days. Now after a product has been expired...

I currently have a macro that prints all visible (unhidden) sheets. Sub Button1_Click() Dim ws As Worksheet For Each ws In ThisWorkBook.Worksheets If ws.Visible=xlSheetVisible Then ws.PrintOut Next ws End Sub I want to have certain required fields be colored with a certain color. If...