Good day
How do I hilight the word in B7 if I type a number or a letter in B7
Thanks
Halla
Good day
How do I hilight the word in B7 if I type a number or a letter in B7
Thanks
Halla
You can do that with conditional formatting.
go to Home > Conditional Formatting > Highlight Cells Rules > More Rules > Use a formula to determine which cells to format
Then you put something like =IF($B$7<>"",1,0) , Like I did on the attached sheet, and It's done! (the 1 on formula means that the cell will be formattted).
highligthB&.xlsx
"The quieter you become, the more you are able to hear"
Any reputation (*) points appreciated.
"If you know yourself but not the enemy, for every victory gained, you will suffer defeat."
Thanks
But this is not what I want
If I type in cell B6, the word I typed in Cell B7 with be hilighted
Monday in B6 Once i type 2 in B7, Monday will be hilighted
See attached Doc
If you type in B1, the word in A1 will be hilighted
Do you know how it is done.test2.xlsx
See the attached file! Tell me if you have any questions!
test2 solved.xlsx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks