Conditional formatting

[a94andwi]

Hello.

I am trying to change a funtion that increase the number of conditional formatting to more than 3 conditions.
This is my function:
Hello.

Please Login or Register  to view this content.

I have tried the routine and it works. I have a problem with one of it's features though.

I want to compare the values to in the target range to a cell D3 in another sheet called "Settings". How can I do that? The value in cell D3 is "705".
I also want be able to format the target range in case I write "OK" in the target range.
What I can see in this code is that it only accepts integer values? How can I change it so that it accepts any kind of values?

/Anders

[Carim]

Hi,

Take a look at previous post ...
http://www.excelforum.com/showpost.p...51&postcount=4

[a94andwi]

Hello Carim.

Thanks. It worked great.
I am using it to check whether I am in a project. If I am three weeks or more before a certain date (In YWW format (year, week)) I want the cell to be green.
If I am two or one week before a certain date I want it to be yellow. If the current week is the week I should present the project it turns orange. If I am one week over time it turns red.
When the project is presented I want to write OK in the cell and it should stay green no matter what week it is.

I would like to add and IF-statement where I check whether a value is greater than or less than one value in the given range.
This to make it stay on a given color if I don't give it a certain value.
It would apply to the first condition and the condition where I am late in the project.

Do you have any Idea how I can do this?
I also want all cells where I have applied the function to to update themselves each week. How can I do this? Recalculate on open or????

/Anders

Please Login or Register  to view this content.