New
#1
If statements in Excel worksheets.
How do you add if statements to formula in Excel that change the formating of the cells.
For instace:
If I have a sum which subtracts one cell from another and I want the colour of the text in the results cell to turn red if the value becomes negative.
And:
If I have a number in a cell and while the number is say 8 then that is fine so I want nothing to change, but if the number becomes say 3 then I want the colour of text in the cell to turn red, how would I go about it.
Regards
AF