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,

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

thanks Dav,


now how do I see the formula behind the value?

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" <TechNoFear.29r3hn_1150890902.7583@excelforum-nospam.com> wrote
in message news:TechNoFear.29r3hn_1150890902.7583@excelforum-nospam.com...
>
> 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
>

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" <TechNoFear.29r3hn_1150890902.7583@excelforum-nospam.com> wrote
in message news:TechNoFear.29r3hn_1150890902.7583@excelforum-nospam.com...
>
> 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
>

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,

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" <TechNoFear.29r8kz_1150897502.1946@excelforum-nospam.com> wrote
in message news:TechNoFear.29r8kz_1150897502.1946@excelforum-nospam.com...

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

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,

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" <TechNoFear.29rczd_1150903203.8587@excelforum-nospam.com> wrote
in message news:TechNoFear.29rczd_1150903203.8587@excelforum-nospam.com...

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

aaah Conditional Formatting


so thats how it's done, excellent,



thank you RD

"TechNoFear" <TechNoFear.29rczd_1150903203.8587@excelforum-nospam.com> wrote
in message news:TechNoFear.29rczd_1150903203.8587@excelforum-nospam.com...
>
> 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

You're welcome, and thanks for the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"TechNoFear" <TechNoFear.29redr_1150905037.0728@excelforum-nospam.com> wrote
in message news:TechNoFear.29redr_1150905037.0728@excelforum-nospam.com...
>
> 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
>