| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting - sort of
I am using VLOOKUP to find a "time" result from a "height" input, and (in
another condition) the reverse of this. The input and output cells work in both circumstances, however I must change the number formatting each time to reflect wether I am inputting (or returning) a time ("00:00") or a regular integer (0.00). Is there a function I can use whereby I do not need to change this formatting...or the formatting changes itself relative to the same condition as the formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| when i sort, how can i get the formatting to sort along with text | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
| Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
Threaded Mode
