**[Solved] Auto Highlight Selected Rows - VBA & Conditional Formatting** *Summary*: In a database with over 10000 rows it's hard to follow each row of data so I was wondering if there's a way to highlight them, but without "damaging" ...

**[Solved] How do I: if X2 = A2, then change X2 to red?** *Summary*: How do I make a cell change color if its value equals that of another cell? Reason: If my "results" # matches my "uploaded" number, I want the "result...

**Highlight every second item AFTER copy + paste as values?** *Summary*: Hello all I have a sheet where I have a lot of items listed in column A. I then have a helper column that changes between FALSE and TRUE if the items ...

**[Solved] How to allow data entered only in cells with color** *Summary*: I am using excel 2013, I have some conditional formatting that changes certain cells red depending on a number entered in a cell. As the user changes ...

**Conditional formatting, highlight alternating values** *Summary*: Hello all In column A I have some numbers. I have a helper column in column CU that checks if the value in that row is the same as the above, if not, ...

**[Solved] Conditional formatting of cells in multiple sheets** *Summary*: I have twelve sheets that each have a total score on cell G10 that I want to have copied to a thirteenth sheet in a specific column (F5-16). What wou...

**[Solved] Multiple Conditional Formatting for Pivot Tables** *Summary*: I am working in a pivot table within excel 2010. There are three columns I am working with, 2 of which are dates, the third is a column with a number....

**[Solved] Excel 2010, using conditional formatting on columns of data.** *Summary*: I have 10 columns of numbers, at the top of each column I put in a master key. I want to hi-light any cell in the 10 columns that contains one of the...

**[Solved] Conditional Formatting and IF/THEN Statements in Excel** *Summary*: I have a spreadsheet with report dates that need to be renewed annually. I'd like to format the date cell to turn red when the date is within 30 days ...

**use conditional format to highlight links in spreadsheet** *Summary*: Apologies if this is a duplicate post. I need to format several worksheets to display cells with links in a specific color. I have used a rangename g...

**[Solved] Need help with conditional formatting for dates** *Summary*: I need to be alerted to a review expiring in 10 days. The reviews are done every 3 months but I would like it to alert me when it is 10 days from exp...

**[Solved] excel 2010 conditional formatting, multiple columns** *Summary*: I'm trying to get multiple columns to change colour, dependent upon a row of cells. So, spreadsheet is set up by week Column B is Wk 1 Cell Ref B2 say...

**[Solved] Conditional formating using values in multiple columns** *Summary*: I am working with a spreadsheet containg columns of data like customer name, year, individual months. The data is downloaded from a sub-system and we ...

**Run Macro doesn't show all the features** *Summary*: Hello, I recorded a macro on excel sheets ,,, but when I run this macro , it didnt show all the feature I have recorded , like the conditional formatt...

**[Solved] Colored if rule under conditonal formatting** *Summary*: Look at Conditional Formatting. 1 - From the Ribbon select Home - Styles - Conditional Formatting, 2 - From the drop down select 'Manage Rules' and s...

**[Solved] conditional formatting depending upon another workbook** *Summary*: I want to do conditional formatting in a range in a sheet say sheet1 in workbook1, depending upon a range in another workbook without coping that rang...

**Conditional formatting between two dates in Excel.** *Summary*: I have a conditional formatting question. I need to compare dates and depending on the result, come back with the correct formatting. This will be usi...

**[Solved] excel conditional formatting mark 3 smallest in column** *Summary*: =rank(ch1200,ch$1200:ch$1211) < 4 is the formula i am using for largest which i gleaned from this site.i have tried every variation in condition 2...

**[Solved] Excel 2007 Conditional cell colouring** *Summary*: I have a spreadsheet (Excel 2007) where I am planning an event programme. I have a series of named cells "band1", "band2", "mc1", "mc2" etc. I then f...

**Condtional formatting in Excel** *Summary*: I have a list of numbers that is currently formatted to turn the text of the highest number green. I also need a formula for the same set that will t...

**[Solved] Changing Font Color in Microsoft Excel 2007** *Summary*: Can someone help me create a macro or tell me how to accomplish the following? I would like to change the font color of the text in a cell depending o...

**Excel 2007 Conditional Formatting Questiond** *Summary*: I have a spreadsheet that lists dates for individuals having last completed an interview. a1=name a2=date interview last complete a3=formula: =DATE(Y...

**excel 2003 Conditional Formatting Help.** *Summary*: this is my situation. I have text in column A and B, I want to compare Column A against Column C, Like if A1 and C5 match, then in Column F, I would l...

**Multiple IF statements in a Conditional Forma** *Summary*: I need some help on getting this correct. I have a tracker/scheduler that shows a persons R&R dates in a line. Depending on the R&R the cells for thos...

**VBA Conditional Format RAG** *Summary*: Hi need help with VBA I need a complicated conditonal format The cells that need to change are E35:T35 Conditons: 1. If E36:T36 equal to or greater t...

**IF/AND Statement or conditional formatting** *Summary*: I am using MS Excel 2007 Ok, here is the data... column G 2% 3.2% 12% ranges (is on a separate sheet and cells): -3.050% 3.050% GRE...

**[Solved] Excel how to conditional format with a macro** *Summary*: How can I write a macro so that it will conditionally format the cells of three different columns? I would like to understand how to write the formul...

**Changing color of a cell if...** *Summary*: I am basically trying to change the color of a if it is before, if its on or if it goes past a certain number of days. Lets say b8 has Jan 1, 2010 and...

**If Statement** *Summary*: I am creating a spreadsheet that utilising two sheets to hold data, and one sheet to show me a summary of the other two sheets. The two sheets that ...

**highlighting with conditional formatting** *Summary*: I have two columns of numbers. One column has 60 rows and the other has 500. All 60 of the values in column 1 can be found in column 2. I would lik...