How do I remove a formula in Excel?
 

Someone has created a formula on a spreadsheet, but it is not working as it
was supposed to, how do I delete this?

How do I remove a formula in Excel?
 

Select the cell containing the formula
Press <Del

Et voilà!

HTH
--
AP

"booboo140184" a écrit dans le
message de news: ...
Someone has created a formula on a spreadsheet, but it is not working as
it
was supposed to, how do I delete this?

How do I remove a formula in Excel?
 

Thanks, but thats not what i meant!
For example, I have the total of all miles driven for one week, there is a
formula to minus off 720 of those miles which I want to keep, but at the
moment the cell with the total, minus the 720, there is a formula which turns
the cell red, which I cannot get rid of. I want this formula kept, but only
turns red when over 2350 miles have been driven. Hope this makes sense!

Thanks

"Ardus Petus" wrote:

Select the cell containing the formula
Press <Del

Et voilÃ*!

HTH
--
AP

"booboo140184" a écrit dans le
message de news: ...
Someone has created a formula on a spreadsheet, but it is not working as
it
was supposed to, how do I delete this?

How do I remove a formula in Excel?
 

"booboo140184" wrote in message
...

"Ardus Petus" wrote:
"booboo140184" a écrit dans le
message de news: ...
Someone has created a formula on a spreadsheet, but it is not working
as
it
was supposed to, how do I delete this?

Select the cell containing the formula
Press <Del

Thanks, but thats not what i meant!
For example, I have the total of all miles driven for one week, there is a
formula to minus off 720 of those miles which I want to keep, but at the
moment the cell with the total, minus the 720, there is a formula which
turns
the cell red, which I cannot get rid of. I want this formula kept, but
only
turns red when over 2350 miles have been driven. Hope this makes sense!

Format/ Conditional Format
--
David Biddulph

How do I remove a formula in Excel?
 

Hi,

Looks like there is conditional formatting at work.

select the cell then select FORMAT, Conditional formatting and adjust
the conditions that you see there.

Regards

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=540204