Hi All,
First time poster here, but I think it'll not be my last!!
How do you change the fill colour of a cell depending on the cells entry?
For example, if the cell is a pass I want to type the letter P and the cell to be highlighted in green and if it's a fail I want to type the letter f and want the cell to be highlighted in red.
I tried to do this using an IF formula, but this creates a circular reference. Is this the way it has to be done, or is there an easier alternative?
I've always thought I was half decent with Excel - obviously not!!
Any help would be appreciated.
First time poster here, but I think it'll not be my last!!
How do you change the fill colour of a cell depending on the cells entry?
For example, if the cell is a pass I want to type the letter P and the cell to be highlighted in green and if it's a fail I want to type the letter f and want the cell to be highlighted in red.
I tried to do this using an IF formula, but this creates a circular reference. Is this the way it has to be done, or is there an easier alternative?
I've always thought I was half decent with Excel - obviously not!!
Any help would be appreciated.