Hi does anyone know how i would go about creating something which "flags up" when a result is a certain number after adding up of totals, e.g. £300+ (total spending)
so at the end of all the adding up if the result is £300+ my excel sheet will flag this up and anything below this number will be left. possibly change the colour of the cell to red for example, is that possible?
thanks
Use conditional formatting option
apply conditional formatting on the cell showing total spending
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
maybe Data Validation
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
okay thanks ill try it, sorry quite new to all of this.
problem solved thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks