Number format based on cell value

[Svedan]

Hi guys,

I've have run into som trouble when trying to sum number with different values. As you can se on the picture below, it doesnt differentiate between Dates and numbers.
Im trying to figure out if it's possible to change the number formatting automatically based on a cell value.
For example if the unit is "Days" I want the number formatting to be Date and if the unit is "hrs" the number formatting to "number"

Untitled.png

[benishiryo]

hi Svedan. try conditional formatting. format the whole column G as General first.
select the range you want to apply to (say from G2:G10 for eg)
go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
=$F2="Days"

go to Format -> Number tab -> Select the date format you desire. if it's not "Days", it will show as General. that will be for the hours.

[Svedan]

hi Benishiryo, your soultion works great, thank you for your help!