R ricky Mar 25, 2010 #1 In MS Project you can customize a field to give a graphic indicator for the status. Is there a way to do it in excel?
In MS Project you can customize a field to give a graphic indicator for the status. Is there a way to do it in excel?
T trip_to_tokyo Mar 25, 2010 #2 EXCEL 2007 You appear to want Conditional Formatting. You may find the following helpful. Go into F 1 Help Facility and type in:- conditional formatting Hit the Search, "button". There is s topic called:- Conditionally formatted data: Examples and guidlines Click on the above topic. Opening the above topic there is a hyperlink about three quarters of the way down the page called:- Conditional Formatting Samples Click on the above hyperlink. A file will open that provides many examples of what you might need. If my comments have helped please hit Yes. Thanks.
EXCEL 2007 You appear to want Conditional Formatting. You may find the following helpful. Go into F 1 Help Facility and type in:- conditional formatting Hit the Search, "button". There is s topic called:- Conditionally formatted data: Examples and guidlines Click on the above topic. Opening the above topic there is a hyperlink about three quarters of the way down the page called:- Conditional Formatting Samples Click on the above hyperlink. A file will open that provides many examples of what you might need. If my comments have helped please hit Yes. Thanks.
