sureshnath
New Member
- Joined
- Sep 2, 2010
- Messages
- 1
Text data
-----------
City Attraction
London eye
London queen
London pubs
NewYork bars
NewYork downtown
NewYork liberty
Paris tower
Paris luvre
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How can I do ? Conditional Formatting Color scale on text based values
- Thread starter sureshnath
- Start date
Text data
-----------
City Attraction
London eye
London queen
London pubs
NewYork bars
NewYork downtown
NewYork liberty
Paris tower
Paris luvre
Excel Facts
Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Similar threads
