Conditional Formatting Related Problems & Solutions

30 tags
Refine Tags

Start a discussion

Results 1 - 30 of 30
[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...

1


Ask Question