Forum Discussion
Format of data in Excel
The format in my column is "Custom" [h]:mm:ss. The entry is 32:22:00 In the dialog box, it shows as a DATE and time, 1/1/1900 8:22:00 AM!! How logical is THAT? When I want to use the data on that...
To add conditional formatting to your worksheet, select the cells you want to showcase and click Conditional Formatting in the Styles group of the Home tab. Select the style of formatting you want to apply, and Live Preview will show how the formatting will look on your data.
