Ready, steady… save!
You don’t need a chart to join in. Here are 2 ways to record your savings:
1. Cross it off
Pop a chart into your first post. Saved an amount? Cross it out! Read more »
£0.01 £0.02 £0.03
2. Write it down
Skip the chart and add updates to your first post. Read more »
“Another +£3 saved today. Go me!”
Use +£ before each new saving so it counts towards your total.
📨 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: 451
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
- 355.9K Banking & Borrowing
- 255K Reduce Debt & Boost Income
- 456.2K Spending & Discounts
- 248.4K Work, Benefits & Business
- 606.1K Mortgages, Homes & Bills
- 179K Life & Family
- 263.9K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.2K Discuss & Feedback
- 37.7K Read-Only Boards