LinkBack URL
About LinkBacks
Hello,
I need help with the IF formula. For example, if cell A1 has a value and if B1 does not, then the cell C1 should highlight automatically. Please help me create this formula.
Hello,
I need help with the IF formula. For example, if cell A1 has a value and if B1 does not, then the cell C1 should highlight automatically. Please help me create this formula.
You cannot highlight cells by entering formulas in cells. You would need conditional formatting for this purpose.
Click on cell C1. Goto Home Tab >> Conditional formatting >> New Rule >> Use a formula to determine which cells to format >> and enter this formula =AND(A1<>"",B1="")
Select formatting of your choice.
Check attached for an example.
Excel Forum - 1263.xlsx
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional. Thanks!
No help to be offered, please, until the OP complies 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks