View Full Version : Conditional Formatting
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
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.
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
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.
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
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)
Thank you VBX for your help and patience.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.