PDA

View Full Version : Conditional Formatting



LLL
02-20-2009, 01:50 PM
I have created a conditional format like the following:

IF I2>H2+2 cell will be red. I would like to enter this for the whole column. Is there a Macro I can input to make this easier for all of column I to meet this conditional formating for the applicable H cells?

Also, if the cell is red, is there a code to have this cell to blink? I would want it to blink until data is inputed in the cell, upon opening of the workbook.

Thanks

Bob Phillips
02-20-2009, 02:27 PM
Select the whole column and add a formula of

=I1>H1+2

LLL
02-20-2009, 02:40 PM
Thanks. Is there a way to have the cell blink if it meets the conditional formatting requirements?

Bob Phillips
02-20-2009, 04:31 PM
No, it would have to be done via event code.

LLL
02-24-2009, 12:57 PM
Regarding the conditional formatting: I would like the following throughout the entire column starting in row 2 of column I.

For example:
I2>H2+2 cell will be highlighted red
I3>H3+2 cell will be highlighted red
I3>H3+2 cell will be highlighted red

And so on through Column I. Is there a Macro that someone could provide me so that I do not have to manually input this information into every cell:dunno

Thanks

Bob Phillips
02-24-2009, 01:01 PM
As I said

Select the whole column and add a formula of

=I1>H1+2


just adjust to start at I2

LLL
02-24-2009, 01:14 PM
Hi, yes. The problem is that it always is referencing I2 and H2. I want this to change through the rows, I3 / H3..I4 /H4 and so on. This does not happen when I do the suggested formula. Thanks for your help

Bob Phillips
02-24-2009, 01:21 PM
Follow my instructions and see what you get.

LLL
02-24-2009, 01:47 PM
Hi I did this and for example I am attaching an example sheet where I have entered the same infor for those columns your review. I got the same result. Column I has one formula already for if H="", then I="", TODAY()

Thanks

LLL
02-24-2009, 01:52 PM
Attached wrong sheet sorry, here it is

Bob Phillips
02-24-2009, 02:08 PM
It would help if you input the correct formula, you want

=I2>H2+2

not

="Is>H2+2"

putting it in quotes, regardless of the fact that you have an s not 2 in there, ensures it is text not a formula.

Might be better also to use

=AND(H2<>"",I2<>"",I2>H2+2)

LLL
02-24-2009, 02:25 PM
Thank you VBX for your help and patience.