Conditional Formatting Formula

[davidingilbert]

Hello all.
I am attempting to do 2 things with my conditional formula.
One - if the date is Cell V2 is before a date in Cell Y2, then the Cell in Y2 turns red.
Two - if there is no date in V2, then Cell Y2 has no color at all.

I got item one to work ok.
I need asssitance with item two.

Thanks folks.
Dave

[dogberry]

Hi

Can you post a sample worksheet so we can see the layout etc dont post confidental information
it will also get you a much better response.


To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.



Chris

[jeffreybrown]

Hi Dave,

Did you try =ISBLANK($V2)

EDIT: Sorry, was thinking of two seperate formulas, not one with two conditions.

[benishiryo]

hi Dave, select Y2 & go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
=AND(Y2>V2,V2<>"")

[davidingilbert]

Hey all.
Thanks for your responses. But something is still not working right.
I am attaching a copy of the spreadsheet.
As you see it in cell U2 (I changed it from the previous post so as not to post anything I shouldn't) it is blank, but cell X2 is red.
I am trying to get it so that if Cell U2 is blank, X2 is white.

Thanks again all.

Dave

[jeffreybrown]

How about

=AND(U2>=X2,X2<>"")

Note: It would be in your best interest to remove all merged cells as it can cause problems. For column X, Y, and Z, why not just column X and then expand the width of the column