I have read several tips however, I cannot get my formatting to work. column X has a formula in it determining whether the issue is open or the number of days...

Hi all I have this conditional format in cell BB35 =IF(BB35$BB$37,TRUE) If I insert cells between BB35 & BB37, then the formula changes to...

Can you help! I have set up an Excel spreadsheet as follows: A B C D E F 1 DATE NAME ...

Hi I'm using Excel 2007 and would like to know how to conditionally format dates so the color changes as per: Green - the last 3 days Orange - 4 to 7 days...

I am using the below to auto change color if it meets the...

I need to specify 6 cell colours according to score 0 = Grey 1 = Red 2 = Yellow 3 = Orange 4 = Brown 5 = Green, for example However you can only apply 3...

While I'm not new to Excel, I am new to using conditional formatting, functions and macros within Excel. I'm working on a sheet that tracks certain data on...

I have a work book that can have up to 100 sheets within it. An example of a sheet is:- Col B Col F Col N Col AM Col AN Col AO Col AP Test...

I have a large spreadsheet with part numbers and prices. Have a second worksheet with part numbers and special prices. I want to have the first sheet cell...

I have some groups and I want each group to have different color(not necessarily distinct). thanks.

I want to apply my formatting to an entire range. I see there are several similar questions posted already but I'm not having success with the answers...

Hello, I would like to know if it is possible to write a formula to do the following. And, if it were possible, how would I write that formula? I would...

there are two columns. the first column is the key column, and the second one is the value column. I want to conditional-format the rows which is the same key...

I have A, B columns, and I want to do conditional-formatting for rows whose A is the same and B is not the same. I mean X 1 Y 2 Z 3 Z 3 Y 1 X 2

I find conditional formatting very useful however I would like to be able to highlight an entire row/range of cells if one cell has a given value, using...

Need to highlight A1 if B1 contains "1", "2", "3", or is empty. What formula can help me do this?

Hi, I can't figure out the way I should create this conditional formatting. It's probably very simple though. If a cell, let's say J5, is empty for three...

I am using Excel 2002 in the office and have many worksheets in a workbook. My first sheet has cells set up as links to the different worksheets. Is it...

greetings......i have a row in which if say a4 contains the word help, then all that row is in red text, othewise it is in black text a1 a2 ...

Hi, Hope you can help. I have created a formula to fill a cell with colour based on the user input. Eg. If cell= "R" then colour cell Red; if cell = "A" then...