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

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

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

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

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

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

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

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

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

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

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

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