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" <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

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
>

"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