Conditional Formatting

[LLL]

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]

Select the whole column and add a formula of

=I1>H1+2

[LLL]

Thanks. Is there a way to have the cell blink if it meets the conditional formatting requirements?

[Bob Phillips]

No, it would have to be done via event code.

[LLL]

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

Thanks

[Bob Phillips]

As I said

Select the whole column and add a formula of

=I1>H1+2


just adjust to start at I2

[LLL]

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]

Follow my instructions and see what you get.

[LLL]

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]

Attached wrong sheet sorry, here it is

[Bob Phillips]

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]

Thank you VBX for your help and patience.