Simple CF help required

damian_r

Active Member
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

Excel Facts

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Andrew Poulsom

MrExcel MVP
Is it?

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

damian_r

Active Member
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

Active Member
Andrew,

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

Anyone got any suggestions?

Damian

Andrew Poulsom

MrExcel MVP
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

Active Member
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

MrExcel MVP
damian_r said:
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

Active Member
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

MrExcel MVP
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

Active Member
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

Replies
3
Views
172
Replies
5
Views
311
Replies
5
Views
132
Replies
9
Views
352
Replies
1
Views
103

1,195,630
Messages
6,010,780
Members
441,569
Latest member
PeggyLee

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back