| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
displaying formulas
Hi, I am trying to see a formula and display formulas isn't doing it for me the column changes from 04:40 04:40 04:50 04:40 04:30 04:50 04:50 06:20 04:50 04:50 to 0.194444444444444 0.194444444444444 0.201388888888889 0.194444444444444 0.1875 0.201388888888889 0.201388888888889 0.263888888888889 0.201388888888889 0.201388888888889 which isn't what I expected the spreadsheet isn't protected and I expected something like if value constant then red else green could someone tell me how to display formulas in this spreadsheet please? tia, -- TechNoFear ------------------------------------------------------------------------ TechNoFear's Profile: http://www.excelforum.com/member.php...o&userid=35622 View this thread: http://www.excelforum.com/showthread...hreadid=554009 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
displaying formulas
The value is just a value and not a formula times are stored as a fraction of a day so 4:40 = 280minutes out of a total of 1440 minutes and hence as a formula it just shows its value 280/1440=0.194444444444444 Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=554009 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
displaying formulas
thanks Dav, now how do I see the formula behind the value? -- TechNoFear ------------------------------------------------------------------------ TechNoFear's Profile: http://www.excelforum.com/member.php...o&userid=35622 View this thread: http://www.excelforum.com/showthread...hreadid=554009 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
displaying formulas
a) click on a cell and look in the formula bar - do you see a formula?
b) CTRL+~ (the key next to 1 on top row of 'normal' keys) will toggle display formulas on/off best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "TechNoFear" wrote in message ... Hi, I am trying to see a formula and display formulas isn't doing it for me the column changes from 04:40 04:40 04:50 04:40 04:30 04:50 04:50 06:20 04:50 04:50 to 0.194444444444444 0.194444444444444 0.201388888888889 0.194444444444444 0.1875 0.201388888888889 0.201388888888889 0.263888888888889 0.201388888888889 0.201388888888889 which isn't what I expected the spreadsheet isn't protected and I expected something like if value constant then red else green could someone tell me how to display formulas in this spreadsheet please? tia, -- TechNoFear ------------------------------------------------------------------------ TechNoFear's Profile: http://www.excelforum.com/member.php...o&userid=35622 View this thread: http://www.excelforum.com/showthread...hreadid=554009 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
displaying formulas
In these cells you have VALUES such as 0.194444444444444 not FORMULAS
When formatted as time, this value displays 4:40. Note that 0.2 (close to 0.1944...)is 1/5th of a day which is 4 hours and 48 mins. So 0.01944.... is 4:40 AM best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "TechNoFear" wrote in message ... Hi, I am trying to see a formula and display formulas isn't doing it for me the column changes from 04:40 04:40 04:50 04:40 04:30 04:50 04:50 06:20 04:50 04:50 to 0.194444444444444 0.194444444444444 0.201388888888889 0.194444444444444 0.1875 0.201388888888889 0.201388888888889 0.263888888888889 0.201388888888889 0.201388888888889 which isn't what I expected the spreadsheet isn't protected and I expected something like if value constant then red else green could someone tell me how to display formulas in this spreadsheet please? tia, -- TechNoFear ------------------------------------------------------------------------ TechNoFear's Profile: http://www.excelforum.com/member.php...o&userid=35622 View this thread: http://www.excelforum.com/showthread...hreadid=554009 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
displaying formulas
thanks Bernard in answer to your two questions a) no b) no it doesn't, that is how I am toggling between one value and the other value I want to see the formula! tia, -- TechNoFear ------------------------------------------------------------------------ TechNoFear's Profile: http://www.excelforum.com/member.php...o&userid=35622 View this thread: http://www.excelforum.com/showthread...hreadid=554009 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
displaying formulas
If you see only a value in the formula bar when you click in a particular
cell, then you have *NO* formula. You *only* have data, where varying formats will change the *display* of the values present. Are you sure that this data was originally produced by formulas and not by simple keying in? Did you perhaps inadvertently remove the formulas and leave the data behind? -- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "TechNoFear" wrote in message ... thanks Bernard in answer to your two questions a) no b) no it doesn't, that is how I am toggling between one value and the other value I want to see the formula! tia, -- TechNoFear ------------------------------------------------------------------------ TechNoFear's Profile: http://www.excelforum.com/member.php...o&userid=35622 View this thread: http://www.excelforum.com/showthread...hreadid=554009 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
displaying formulas
Hi RD, if it isn't a formula, then there must be another way of affecting display. This particular column is green in colour and empty. A user types in a value in the format nn:nn i.e, a time like 4:30 If the time is before 05:00 hours, the cell remains green, however, if the time is later the cell turns red. I presumed it was a formula, can you tell me how it's done please? tia, -- TechNoFear ------------------------------------------------------------------------ TechNoFear's Profile: http://www.excelforum.com/member.php...o&userid=35622 View this thread: http://www.excelforum.com/showthread...hreadid=554009 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
displaying formulas
Click in the cell, then:
<Format <Conditional Formatting And you'll see any *formatting* formulas for that cell. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "TechNoFear" wrote in message ... Hi RD, if it isn't a formula, then there must be another way of affecting display. This particular column is green in colour and empty. A user types in a value in the format nn:nn i.e, a time like 4:30 If the time is before 05:00 hours, the cell remains green, however, if the time is later the cell turns red. I presumed it was a formula, can you tell me how it's done please? tia, -- TechNoFear ------------------------------------------------------------------------ TechNoFear's Profile: http://www.excelforum.com/member.php...o&userid=35622 View this thread: http://www.excelforum.com/showthread...hreadid=554009 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
displaying formulas
aaah Conditional Formatting :) so thats how it's done, excellent, thank you RD -- TechNoFear ------------------------------------------------------------------------ TechNoFear's Profile: http://www.excelforum.com/member.php...o&userid=35622 View this thread: http://www.excelforum.com/showthread...hreadid=554009 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
displaying formulas
"TechNoFear" wrote
in message ... Hi RD, if it isn't a formula, then there must be another way of affecting display. This particular column is green in colour and empty. A user types in a value in the format nn:nn i.e, a time like 4:30 If the time is before 05:00 hours, the cell remains green, however, if the time is later the cell turns red. I presumed it was a formula, can you tell me how it's done please? Conditional formatting -- David Biddulph |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
displaying formulas
You're welcome, and thanks for the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "TechNoFear" wrote in message ... aaah Conditional Formatting :) so thats how it's done, excellent, thank you RD -- TechNoFear ------------------------------------------------------------------------ TechNoFear's Profile: http://www.excelforum.com/member.php...o&userid=35622 View this thread: http://www.excelforum.com/showthread...hreadid=554009 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How prevent formulas to get external references/path to current workbook? | Excel Worksheet Functions | |||
| Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
| locking formulas?? | Excel Discussion (Misc queries) | |||
| Need Formulas for counting multiple conditions | Excel Worksheet Functions | |||
| Problem with named formula's | Excel Worksheet Functions | |||
Linear Mode
