Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
putting colour in a cell containing
Name: seny69 Date: March 5, 2009 at 02:16:33 Pacific OS: Windows XP Subcategory: Document Management
Comment:
I was wondering if macros can help in my problm.I am preparing an excel sheet one for each day of the month the values varry , i want to know if Macros can help me to colour the cells according to its valu eg. If value is more than 99.8 then it should show green otherwise yelow
Summary: I have a simple array function in a cell to total up the number of dancers who attended the dance AND who were at the Plus dance level: ={SUM(IF(F8:F50="*",IF($T$8:$T$50="p",1,0)))} .. The "*" marks a...
Summary: In MS Excel 2007 the question is, using only a Formula (no VBA), how to determin is the string in a cell contains any key words listed out on another sheet. Example: Assume cell A2 contains the text: ...