In cell J4 I have a specific date, Is there a way to format B4:P4 if J4 date is today?
In cell J4 I have a specific date, Is there a way to format B4:P4 if J4 date is today?
What do you mean by 'format'? Formatting is not controlled via formulae - do you mean change the contents? What EXACTLY are you trying to do?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Specifically what i want to do is to identify if J4 date is today and if yes then automatically format B4:P4 with a color.
Use this as the CF fromula and apply it to B4 to P4.
=$J$4=TODAY()
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
You cannot do that with a formula in a cell. There are two ways to do it... one is with Conditional Formatting (see Message #4 for that solution) and the other is with VBA code. Here is an event procedure which will do what you asked for...
HOW TO INSTALL Event CodePlease Login or Register to view this content.
------------------------------------
If you are new to event code procedures, they are easy to install. To install it, right-click the name tab at the bottom of the worksheet that is to have the functionality to be provided by the event code and select "View Code" from the popup menu that appears. This will open up the code window for that worksheet. Copy/Paste the event code into that code window. That's it... the code will now operate automatically when its particular event procedure is raised by an action you take on the worksheet itself. Note... if you are using XL2007 or above, make sure you save your file as an "Excel Macro-Enabled Workbook (*.xlsm) and answer the "do you want to enable macros" question as "yes" or "OK" (depending on the button label for your version of Excel) the next time you open your workbook
Last edited by Rick Rothstein; 09-01-2019 at 02:35 AM.
This is exactly what i wanted, the code worked perfectly.
Thank you very much Rick
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks