Using Conditional Formatting in Google Sheets

Escrito Mind  > Life, Technology >  Using Conditional Formatting in Google Sheets
close up photo of survey spreadsheet

Shop now!

So, due to using the Google Finance formula in the expenses tracking sheet, I realise that I didn’t have a formula to track my money movement. I wanted to know if it was going out or coming in. Considering that outgoing money is rather common, the tracking sheet looked more like a sheet for loss rather than a balance sheet that companies would be using.

So, I decided to use conditional formatting by inputting another column to state the movement. Based on the selection, the amount would change in text colour. As much as I would love to use Google Finance to look up the currency exchange rate only once, it is unfortunate that I have yet to find a solution to use the Google Finance to look up only on a particular day since it will be doing it real time.

Hope Fashion

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

10% discount voucher