I have a simple sheet for logging incoming sales. The sheet has 6 columns
A= Sales person
C= Order value
D= Date of order
E= Follow up date
In column E I have setup a simple cell drop down list with 4 options.
I have used conditional formatting to give visual indication of the status. No points for originality but 1 = Green, 2 = Amber 3 = Red. My problem is scenario 4, I have run out of options in Conditional Formatting.
I would like to be able to turn the font red, bold the type and make the original value entered into a negative value. ie. Original sale value was £2,000 would return -£2000 if last column is set to "Cancelled"
Any ideas, I am stuck now!
Thanks in anticipation