LinkBack URL
About LinkBacks
Dear All,
Would you ple help me for below formula request?
if A2 is not empty, then make empty cells RED COLOR in B2:AF2, and apply this rule to A2:AF5000
Dear All,
Would you ple help me for below formula request?
if A2 is not empty, then make empty cells RED COLOR in B2:AF2, and apply this rule to A2:AF5000
Try applying the following CF rule to range B2:AF5000:
=AND($A2<>"",B2="")
Like this:
=AND($A2<>"",B2="")
Edit: Duhh !! Too slow, Kennedy.
BtW, You'll probably need ; instead of ,
Last edited by Glenn Kennedy; 08-20-2017 at 01:35 PM.
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
fast, very fast. thx guys..
by the way, why you added "$" only to A2?
If you didn't do that, then - when it looks in column B, it would look for a non-blank in B. The $ anchors it so that the first condition is always sought in column A, the second condition is sought in each individual cell.
Anyhow..
You're welcome.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
Thx Glenn, Thx Root_
i feel lucky
If you keep coming here with your problems... you usually will be. This place was a huge help to me when I was starting out...
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Dear AliGW,
I thought i should open new threads for different questions. No problem, i can continue writing here.
Read my instructions carefully. Cross-posting is when you post the same query on OTHER forums without providing links here - you have posted on at least three other forums. You will get no further help here until you comply with these rules. Do not open duplicate posts to try to get round this rule.
Last edited by AliGW; 08-21-2017 at 01:26 AM.
Dear all,
i need your help for below formula for conditional formatting
MAKE A2 GREEN IF B2:AG2 ARE FULL & ANY CELL VALUE IS NOT "?" and apply this to A2:AG5000
Turkanet, is this Q also posted on other forums?
no glenn, i wrote only here.
=AND($B2:$AG2<>"",$B2:$AG2<>"?")
see sheet. I manually highlighted some blanks and ? for checking
thx glenn really
You're welcome.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks