I would like to know how to change the colour of text in Excel, but change it in a formula. For example, I wish to use a formula that will change a number to RED when the number falls below a certain threshold. It would be something like this:
=IF(CELL<1000,BLACK TEXT,RED TEXT), only the words would be changed for the references I need.
The background is as follows: I do all of my accounts using Excel, and I have a weekly income. I want the weekly income figure to automatically turn red if it is below a certain threshold. I can also incorporate this idea into many other aspects of my accounts.
If anyone could help I would be grateful.
