<DIV id=post_message_1553111>Hi,
I have a range of cells that conatain 3 conditions
1) =ISERROR(R11)
2) =R11
<DIV id=post_message_1553111>Hi,
I have a range of cells that conatain 3 conditions
1) =ISERROR(R11)
2) =R11
<DIV id=post_message_1553111>Hi,
I have a range of cells that conatain 3 conditions
1) =ISERROR(R11)
2) =R11
<DIV id=post_message_1553111>Hi,
I have a range of cells that conatain 3 conditions
1) =ISERROR(R11)
2) =R11
Last edited by 007juk; 04-26-2008 at 02:06 PM. Reason: problem when I inserted link
Apologies don't know what happened with 1st post.
<DIV>Hi,
I have a range of cells that conatain 3 conditions
1) =ISERROR(R11)
2) =R11
oh seven, Could you explain your question please?
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Sorry Lucas, won't let me post it. Keeps coming up with that <DIV id post???
In my first post I tried to post a link, think that caused the problem.
Thanks.
I have a range of cells that conatain 3 conditions
1) =ISERROR(R11)
2) =R11
I have a range of cells that contain 3 conditions
1) =ISERROR(R11)
2) =R11
3) =R11>TODAY() formatted green
a) If cell R11 is true (contains a expiry date then format red)
b) If cell R11 is true (contains a live date then format green)
c) If cell R11 is false (doesn't conatin a date yet formats green)
In relation to (c) I want it to remain blank and not to format green, because it doesn't contain a date.
Many thanks,
007,
Please stick to one thread to get help. You created 3 new threads asking the same question. I know you are having trouble posting but lets try to solve it in this thread.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
=AND(R11<>"",R11>TODAY())
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber