This is a 3-minute video that shows how to copy and paste the values from an Excel formula into the same column using 2 different methods. This video supplements our Simple Methods to Copy Excel Formula Values tutorial and spreadsheet file. It is suggested you read that article and download the example worksheet.
Below is a short video showing you how to use Excel’s conditional formatting feature. You can see the full steps from this tutorial.