highlight cells

Hello to all, I am truly stumped. I searched but couldn't come up with anything that works. I am trying to highlight a number of cells based on a count not values. In other words if A1 has a number 5. I would like A2:A6, next 5 cells, to automatically highlight. I would prefer something in VB...

Hello: I have some data shown below in a spreadsheet. <colgroup><col span="2"><col><col></colgroup><tbody> g z g s r b* h c n u* e r </tbody> Each string (g, z, u*, b*...) is in its own cell. I am trying to highlight the cells that has *. I tried Conditional Formatting...

Hello, I would appreciate any help.. I have a list of words which I would like to know if column C contains each one of them in each cell, if it's true I would like to highlight the cell in red. any ideas? with conditional formatting I'm able to create one rule for one each each time.. for...

I have a fairly large spreadsheet which I use for tracking progress, I have dates in columns D-G in two styles "good" i.e. Green and "bad" i.e. Red, I need a macro that will highlight cells with past dates that are considered "bad" as these should always be future dates. The cells that are...

I have a spreadsheet set up that tracks employees and their training dates. I go into the spreadsheet periodically and highlight expired trainings yellow. Is there a way to make the cells automatically turn yellow if the date is past today?

All, I have values in Column H in a file that could be big or large (so the # of rows is unpredictable) Data could be something like: 1 2 2 3 4 4 4 4 5 5 6 I'd like to do the following: Highlight all consecutive duplicates as one color, and extend highlight to the entire row, not just that...

Similar to this thread http://www.mrexcel.com/forum/showthread.php?t=616627 I am looking to highlight values based on a selected cell. However, would also like the other values in the highlighted cell's row to be used as inputs for the next search and highlight those values as well. Can...

I have Excel 2010 and I have looked high and low for an answer to this question . . . I have a drop down menu that changes the values in a corresponding table. The possible drop down selctions are: <TABLE style="WIDTH: 128pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0...

I wish to open each xls file one by one in the main directory D:\BRDSORT and each of it's subdirectories upto 2 levels and run the following macro on Sheet1 of each file. Macro: Sub Highlight() Range("E9:H13").Select With Selection.Interior .ColorIndex = 34 .Pattern =...

I have a question. Here is the example: If A1=20, I want to auto highlight 20 cells. If value in A1 change, the cells highlighted auto changed. How can I do it in Excel 2007?

Dear All, I have one column of Site ID's sorted with respect to certain ratio. Also I have Same Site ID sorted with another criteria say demand. I would like to select or highlight site IDs with Ratio greater than 5 from sorting with demand column. Can you please help with it? E.g. Site...

How to highlight a cell that contains more than 50 characters using conditional formatting? Please let me know your suggestions. Thank you in advance.