Conditional formatting

[007juk]

<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]

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]

oh seven, Could you explain your question please?

[007juk]

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]

I have a range of cells that conatain 3 conditions

1) =ISERROR(R11)

2) =R11

[007juk]

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]

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.

[Bob Phillips]

=AND(R11<>"",R11>TODAY())