conditional formating...

Losing my mind...I have done this so many times...failing now I am... Two columns I would like to compare. Green if less. Red if more. Trying: Conditional Formatting, Use Formula (Highlighting all the cells in column E before I begin the process) Formula: =$E2>$D2 (and applying the format I...

Cell H2 will either contain a Y or N. Cell I2 will contain a date. I want to highlight I2 if it is in the current week only if H2 contains Y and I2 is minus one month. So I guess I want reminded one month before the date in I2 but only in the current week. Not sure if I'm on the right track...

I have created a multi-sheet workbook for a friend. Occasionally he has entered data into cells with formulas and thus destroyed the logic. I want to show him the error of his ways by formatting all cells with formulas in a distinctive way. I have already provided his workbook with a UDF that...

So I've applied conditional formatting to columns A and B to highlight and bold any blank entries. However since those guys tend to show up a thousand rows or so down I don't have anything to alert me that there is a problem. I know that I can just filter those columns to check but I'm not the...

Thanks for looking.Im looking for some code where if the cell contains the value G4474 it will highlight the row. The value could be different variables such as G4474-456-5 or G4474-200 or just G4474 and so on.....

I created a workbook with 4-5 conditional formatting formulas (and/or statements). It worked for a few days, but now excel freezes each time I try to open the workbook. Any ideas into why this is happening?

Hi, Could some one help me with a conditional formatting for the undermentioned condition: I have data as under in two columns <tbody> Individual Average Team Average 00:03:55 00:02:00 00:03:55 00:05:00 </tbody> What I am aiming to achieve is as under 1. If the individual Average...

Am having a problem with conditional formatting in sheet. I have two columns i wish to compare with one another and automatically fill according to this rule where the values in column J are greater than I. I have used conditional format with the formula =($J$3:$J$90)>($I$3:$I$90) and then fill...

Hi, the formula below works perfect for me & i hope it is correct. K, what 'm looking is that i put a formula in conditional formating and it hilght where the formula result is from...("B$2:$NB$15") i have data that looks almost alike eg X, Y, Q etc... Thanks for helping. Pedie In the huge...