Hi Experts,
I have excel sheet with multiple nonblank and blank cells. I need cell color to be highlighted when we enter the value in empty cells. Attached the sample input and manually mocked output in sample file. Please help me on this!!
Thanks in advance.
Manikandan Arumugam
Excel Learner
I don't understand.... Do you want ONLY blank cells to be highlighted?
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
If so, use:
=ISBLANK(A1) as the Conditional Formatting formula.
you currently have a conditional format rule set as "Format only cells with" NO blanks...just change that to "Blanks" instead
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thanks for your help, Glenn and Humdingaling. What i created is wrong. I want blank cells to be highlighted when they keying (modifying anything in blank cells) something in blank cells. Hope, you understand.
Maybe this is what you want (two options for you...). Enable macros on opening as this requires VBA...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks