In J4 there a specific date, I want to conditional Formatting B4:P4 to yellow if that date is reached, after that the color will become permanent until P4 = text "*Complete*"?
In J4 there a specific date, I want to conditional Formatting B4:P4 to yellow if that date is reached, after that the color will become permanent until P4 = text "*Complete*"?
To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
In this example when the date is today it will conditional format B4:P4 in color green. But i need instead of only formatting today date, to after the specific date J4 in that case 09/03/2019 is reached than it will remain filled with green until R4 "complete" is selected from a list. If R4 "Complete" is selected than B4:P4 will go back to normal.
Try changing the CF formula to...
=AND($J$4=TODAY(),$R$4<>"Complete")
After changing the date J4 to 09/04/2019 , the CF stopped filling B4:P4. I would like to after J4 date is reached than it would remain filled for any succesive date until R4 "Complete" is selected. Is that feasible with a formula?
OK you need to decide if you want this based on the actual date you entered in J4, or if you want it based on today's date?
Sorry about the confusion, I want based on the actual date entered in J4.
And you want to to test for any date = or greater than J4?
Maybe this?
=AND($J$4<=TODAY(),$R$4<>"Complete")
After J4 date is reached , than it will permanently fill wil green color until R4 "Complete" is selected.
J4 = 09/03/2019
Example:
09/03/2019 is 09/03/2019
09/04/2019 is 09/04/2019
09/05/2019 is 09/05/2019
09/06/2019
Than R4 Complete is selected and it will go back to 09/06/2019
In this example the font color was changed to green but like in the workbook it supposed to be filled with color green by CF.
This formula worked well ,
Thank you very much for your help.
What was the final solution on this thread?
I have a similar issue where I want a fill color in a cell if certain conditions are met and I believe the answer is here.
But - I do not see the solution anywhere. Just see a "The formula worked well".
Thank You!!
I made a suggestion in post #9 that the OP seemed to be able to work with.
Mr.Castle, thanks for the feedback and happy to help
OK Thanks
I saw that, but, I thought one of the primary goals was for font color to change in certain situations and I did not see that solved.
Yes that formula would achieve that.
Trying to do some clean up but can not figure out how to get this marked Solved.
Can you do a Solved on this?
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks