Matt H Posted November 23, 2007 Share Posted November 23, 2007 Need a bit of advice on how to do something in excel for work. Basically, i need a cell to change colour based upon the numeric value thats in it, i.e, if D9=5 then D9 should then be filled red for exampe. Does anyone know how to do this? being trying an IF command but cant seem to find anything that would produce a colour fill Ta Matt Quote Link to comment Share on other sites More sharing options...
Todd Posted November 23, 2007 Share Posted November 23, 2007 Conditional formatting Quote Link to comment Share on other sites More sharing options...
Todd Posted November 23, 2007 Share Posted November 23, 2007 http://www.digitalsurvivors.com/archives/000351.php Quote Link to comment Share on other sites More sharing options...
AndyT Posted November 23, 2007 Share Posted November 23, 2007 Nice one Todd. Quote Link to comment Share on other sites More sharing options...
Matt H Posted November 23, 2007 Author Share Posted November 23, 2007 Cheers Tod Job done Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.