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.
Excel Formula
Name: R.Suthan Date: July 18, 2009 at 01:44:38 Pacific OS: Windows XP CPU/Ram: 2G Subcategory: Configurations
Comment:
Hi Can someone write me a formula for changing colour of cell depending on the value? Say for example if cell A1 has value £1545.50 and B1 has £934.34 I want see on cell A5 difference between A1 and B1 to be appear in cell A5 (A1-B1). If the value in cell A5 is zero then background colour should change to yellow and if the vaule is below zero then background colour should change to red and if the value above zero then background colour should appear green.
Summary: Before Christmas, our organization changed from Novell Groupwise to MS Outlook. IT did a remote uninstall of the local Groupwise. However, now Excel 2007 opens with debugger showing a "Compile error:...
Summary: Worked for me. Column G cell g1 12345 cell g2 23456 cell g3 12345 Column M cell m1 formula =left(g1,2) gave 12 cell m2 formula =left(g2,2) gave 23 cell m3 formula =left(g3,2) gave 12 Cell M5 =count...
Summary: I have a list that has multiple columns, two of the columns have the same name for mailing, I would like to create a formula that can identify which columns have matching names and ultimately eith...
