condition formatting

Hi all. I am working on a large data entry and reporting system in excel. Currently the area of drop down boxes covers 1.3 million cells and will probably end up double that. I was using excels inbuilt conditional formatting to grey out box's that are contain an "X" to improve the user...

I am going to draft one report which will compare data with previous month. Here, I have attached example sheet to give more ideas on it. I would like to compare beside column data and set up background color for better understanding and easy to read this report. So, How can I do it on excel? I...

Hey guys.. I need some help So sheet 1 has the below data Cell A2, A3 and A4 have 1, 2, 3 respectively and Cell B1, C1 and D1 have 2, 3, 4 respectively I want excel to highlight matching cells in B1, C1 and D1 by searching A1,A2 and A3 Is there a formula or macro that can do that?

In cell C1 I have done CF. C1=D1. CF (in C1): CF1: If cell value>0, back ground color1 Output required: I want to check value in B1. B1 generates thr’ formula either of 1,2,3,4 or null. If B1=either of 2 or 3, then MODIFIED CF (in C1) required as: back ground color2 if B1=2 with a text in C1...

Hi I now have an issue I am trying to solve where a cell in sheet 2 (any cell) will either carry or not carry a value which exists in a list in sheet 1. I would like to colour this cell in sheet2 based on a value in sheet1. below is what I am trying to acheive.... So if a cell on sheet 2...

As i m using Sum Values with condition "Sumifs" but now i want to get the same value with condition As i attached he picture, i want Column#F to write the Value from Column#A If Column#B have same value as Column#E For Example Column#F should Find "1" in Column#B and then write the Value...

I want to use the following conditional format to highlight the row when anyone of these three is chosen from a drop down menu but nothing happens. I can however break it into 3 different conditional formats which works great but I want to apply this rule to several sheets thereby cutting it...

Hello, I want to apply a simple conditional format to a large number of cells. Format: if =F6<>U6 and apply this condition to U6 I have a range of values like this, so the next in the series would be if: =G6<>V6 apply this condition V6, next is if =H6<>W6 apply this condition to W6, and so...

So I'm using a 2011 version of Excel on Mac OS 10.7 and I wanted to highlight a cell with yellow using the condition that two other cells in a different row have matching values (namely "Amount in Shed" <= "Reorder Amount"). This works fine using the formula "=IF(J8<=L8,1)". Now, each row...

Hi! I'm using Excel 2010 (Windows 7) to develop a workbook with the goal of tying conditionally visible worksheets to a case statement. Conceptually, I want a user to enter a password and click on the enter password button, and have the sheets they are authorized to see appear in the tabs...

Hi, I'm looking to implement a rule so that when a specific resource is selected for an assignment, a check is done through the existing data to see whether they are already 'booked' for work within that calendar period. I've put together an example here...

Hello I'm trying to set up C. formatting for multiple text cells. Currently I have to add about 180 C. formatting rules to a single cell. The first tab “Agents”, I have a static list of names. Each column represents a working shift (i.e. B1 = 7am–4pm, C1 = 8am–5pm, etc…). Below those cells is...

Hi, I'm looking to apply conditional formatting based on the value of the adjacent cells. So using the example below, I want to highlight the figure showing for Q4 if it is 10% greater than the value in Q3. (However that figure in Q4 is a forecast in which I will be using trend function - not...

I'm completely new to VBA but I found some very helpful code in an older thread: http://www.mrexcel.com/forum/excel-questions/543349-extract-text-between-two-points.html Thanks Gary, that's accomplised what I was originally failing to do with MID() :) but what I'm hoping someone can show me...

Hi I am trying to merge cells with conditional formating. I am trying to represent below but its hard. hope you guys understand what I need. Ie: 1.I would like to merge From Jan1 to Jan 4 and write insde the merged cells "A" 2.Merge Jan 5th to Jan 9th and write inside the merged cells "B"...

Using Excel 2010, I'm trying to apply Icon Format Style to values of a PivotField The refence to determine which icon to apply is in anotherPivotField How do I do this ?

Hi, I need to: 1. Find a column containing the word 'target' in header. (from the range P1 to QI1 ) 2. Delete all other column without 'target' in its header. Sub Cleanup() Dim rng As Range With ActiveSheet.Range("P1:QI1") Set rng =...

<tbody> sl.no customer ID A gain target A gain target Value A loop target A loop target value A Loop high A loop high value B Gain target B loop target B loop high 1 345 345 1 345 45 34 45 67 2 234 3466 1 2345676 1 67 1 76 56 67 3 123 3457 34567 456...

Hi Folks, Im new to the site, and will appreciate any help that you can give! Thanks... I work for a Construction company that recieves daily maintenance jobs from our clients that have target dates. I am looking for a tailored solution to my problem please: I basically what to open my...

I am a first time poster, so not sure if this is where this question belongs. I have Excel 2013 (and 2010) installed and know how to do color scales and how to do custom formulas but here is my delimma and not sure if it's possible. I have an excel with >50 columns of data, each column is an...