good day to all.
i am trying to write a formula and not doing so well.
i have a chart that is a sample log and would like the ROW to be greyed out once the line item is completed, which is accomplished by entering a date in column N.
so, if the cell is BLANK, no formatting needed but once a date is entered in column "N", then that row should be greyed out.
can someone walk me thru the steps to make this work pls?
thanks!
Welcome to the forum.
With A2 selected:
=$N2<>""
Use the Applies to box to select the range (e.g. $A$2:$Z$100).
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.
thanks so much, Ali but this greyed out only the N2 cell; not the row.
how to apply this to the entire row pls?
Select the entire range you want to highlight (lets say starting at N2:Z100 - adjust the range as necessary)
Conditional Formatting
New Rule
Use a formula to determine...
=$N2<>""
Format as required
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
If you’d followed the instructions at the end regarding the Applies to box, it would have worked.Originally Posted by soopial
If you find it easier Special-K’s way, do it that way.
much appreciated but alas, i could not find the "applies to" box.
i will try Special K's method now...
it worked! thanks so much to you and Ali...you both saved my day!!
Administrative Note:
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks