We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
excel query
onthemend
Posts: 444 Forumite
in Techie Stuff
does anyone know how to change the colour of a cell based on the value of that cell?
We are doing some financial stuff at work and it would be useful in our job costings column to make a cell go green if the value of that cell is +ve and go red if it is -ve.
We are doing some financial stuff at work and it would be useful in our job costings column to make a cell go green if the value of that cell is +ve and go red if it is -ve.
0
Comments
-
you need to set up conditional formatting.
Highlight the cells you want to work with then click format and conditional formatting.
It should be self explanatory from there but let me know if you need any more help
Duncan0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 352.5K Banking & Borrowing
- 253.7K Reduce Debt & Boost Income
- 454.5K Spending & Discounts
- 245.5K Work, Benefits & Business
- 601.5K Mortgages, Homes & Bills
- 177.6K Life & Family
- 259.5K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards