PDA

View Full Version : Conditional formatting



007juk
04-26-2008, 02:04 PM
<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

007juk
04-26-2008, 02:08 PM
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

lucas
04-26-2008, 02:17 PM
oh seven, Could you explain your question please?

007juk
04-26-2008, 02:19 PM
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.

007juk
04-26-2008, 02:20 PM
I have a range of cells that conatain 3 conditions

1) =ISERROR(R11)

2) =R11

007juk
04-26-2008, 02:28 PM
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,

lucas
04-26-2008, 02:35 PM
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.

xld
04-26-2008, 03:33 PM
=AND(R11<>"",R11>TODAY())