Get instant live expert help on I need help with excel if contains
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Cell E4 contains formula. I would like to highlight it (Cell E4) if it's overridden manually in Excel 2007.
Solved by V. S. in 30 mins
If column "I" contains __ and column "F" contains __, __ or __, then color column "F & G"
Solved by V. J. in 26 mins
If cells A1:A20 contains sh1, produce 1BD in B1:B20, if cells A1:A20 contains sh2, produce 2BD in cells B1:B20
Solved by V. Q. in 30 mins
Need help with IF formulas, IF contains ___ "Yes", "No", etc
Solved by Z. F. in 23 mins
please help populate column contents of 1 of 7 options. The formula should look in a single column for the digit 1,2,3,4,6 or it should understand that it is "blank". It should then populate with the contents of different columns accordingly. For example if it contains 1, should print text from cell A1, if its 2, B1, etc Actual references are: If K3 contains 1, print text of AH3 in AG3 If K3 contains 2, print text of AI1 in AG3 If K3 contains 3, print text of AJ1 in AG3 If K3 contains 4, print text of AK1 in AG3 If K3 contains 5, print text of AL1 in AG3 If K3 contains 6, print text of AM1 in AG3 If K3 is blank, print text of D3 in AG3
Solved by X. Q. in 28 mins