Simple CF help required

[damian_r]

Hi folks,

I'm having major brain fade today and can't get the following to work.


In cell B28 i have placed the following formula

=IF(R28,(R28<=$E$2),(R28=""))

Currently cell B28 has a shaded background and i'm trying to make this formula remove the shading (by replacing it with a background of white in CF) if cell R28 is todays date or in the past, when compared to cell E2 which is actually a =TODAY() cell. If there is nothing in cell R28 then B28 is to keep it's current shading

Any help would be appreciated.

Damian

 

[Andrew Poulsom]

Is it?

=OR(R28="",R28<=$E$2)

 

[damian_r]

Andrew,

Thanks for this, i've only just remebered this post i made and thought to check it.

I'll give the formula ago and see what happens


Thanks

Damian

 

[damian_r]

Andrew,

OK, i've given this formula a whirl and it's not working.

Anyone got any suggestions?


Damian

 

[Andrew Poulsom]

ADVERTISEMENT

I put that Conditional Formatting formula in B28. If R28 is "" or contains eg 11/11/05, B28 is shaded. If R28 is eg 12/11/05 B28 is not shaded.

Seems to work for me.

 

[damian_r]

Ahh, i think i see what is happening here.

I think that from what you've said teh formula will shade a cell if there is nothing in it when i'm trying to make cell B28 not shade when R28 is empty.


Damian

 

[Andrew Poulsom]

ADVERTISEMENT

Ahh, i think i see what is happening here.

I think that from what you've said teh formula will shade a cell if there is nothing in it when i'm trying to make cell B28 not shade when R28 is empty.


Damian

The formula refers to R28. If you put it in B28, it will shade/unshade B28, depending on the contents of R28.

 

[damian_r]

The formula was put in cell B28 (as that is the sell in which the removal of shading is to take place)

So, the "" value means that if cell r28 contains nothing then B28 will shade. Am i right?

If i am right, how can it be set up that if cell R28 is empty, B28 does not shade adn then if R28 is today's date or in the past, it shades?


Damian

 

[Andrew Poulsom]

To shade B28 if R28 is less than or equal to today use the fomula:

=R28<=$E$2

If R28 contains a date greater than today or "", B28 won't be shaded. That's because "" is greater than any number in the sort order.

 

[damian_r]

it must be me . . . . .

surely this means that if cell R28 is completley void of any data, B28 will highlight as R28<$e$2?????

Damian