Dears,
how to make formula for;
if any cell in A2:AF5000 is "?", then make cell in yellow color
Dears,
how to make formula for;
if any cell in A2:AF5000 is "?", then make cell in yellow color
for 2007, 2010 , 2013 or 2016 excel version
Conditional Formatting
Highlight applicable range >>
a2:af5000
Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=a2="?"
Format… [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Rule 08: Cross-posting Without Links
Your post does not comply with Rule 8 of our Forum RULES. Do not cross-post your question on multiple forums without including links here to the other threads on other forums.
Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.
Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!
Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).
No further help to be offered, please, until the OP has complied with this request.
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.
thank you etaf
You have not yet provided a link to the other forum where you have asked this same question. Please do so.
The only sensible thing to do with heavy cross-posters is, whenever applicable,soft-deleting ( hiding) all answers already given as long as OP has not provided the requested links.
Not much point here: the cross-post wasn't reported until AFTER the OP had received the help (look at the time stamps). However, he will not be receiving any further help here or in any other thread until moderation requests are complied with.
Trouble is (I think) that email notifications automaticlly sent out to OPs often contain enough to solve the issue.
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
1. That's why I added " whenever applicable"
2. The cross post report was posted by you yesterday evening, and the OP did not react before this morning. There is a good chance he did not connect between the two. So, if you had soft deleted the answers it "might" have produced a result
3. Yes I can read time stamps. After years of moderating I should know what I'm talking about, wouldn't I?
From forum rule #6B:
Thanks for your cooperation.The current moderating staff will moderate. What's past is not always relevant to current moderation needs or decisions. Moderators too are just people. When perceived errors occur point them out politely via private message or the REPORT feature.
By the way:
No, in fact I responded to a report logged by someone else.2. The cross post report was posted by you yesterday evening, ...
Last edited by AliGW; 08-21-2017 at 06:24 AM.
Dear Moderators & Experts
This is my first experience on foreign forums negotiating my excel formula-vba requirements. Yes, i have read forum rules, but i really didnt know that to ask same question to another forum means a big event. in my native forums, you may ask it to wherever you want, and nobody will claim you only because you need a fast help. Anyhow, of course i understand what do "rules" mean, and i will act accordingly. thank you.
The reason for the requirement is simple.
We give our time for free. We may get some Reputation points, that's all - any they cost you NOTHING
Our time is limited.
I (for one) get very annoyed if you have posted the same Q on several sites and not told us because...
You may have had a good answer hours ago. If I spend 20 minutes on the same problem,
IT IS A WASTE OF MY TIME.
I'll never get that time again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks