Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
bell7526
 
Posts: n/a
Default Conditional Formating

How do I get the cell to highlight or letters to change color when someone
changes the content in a cell. Example is I want to have a formula in a cell
that is a projection and if someone types a plain number over top it to
adjust the project I want it to highlight. so if the formula calculates 75
and they want 100 they just key it over the formula and the cell will
highlight that there was a change. Can someone help me?
--
Billy Bellamy
  #2   Report Post  
TomHinkle
 
Posts: n/a
Default

That's Funny!!
I actually JUST wrote the exact same function about a week ago!! I was
afraid the user might forget they overwrote a cell..

Put this code in the worksheet_change event of the worksheet your data is in..

Private Sub Worksheet_Change(ByVal Target As Range)

' All this if does, is limit the color change to a specific region of the
worksheet
If ((Target.Column() 39) And (Target.Row() 1)) Then

If Target.HasFormula Then
Target.Interior.ColorIndex = xlNone
Else
Target.Interior.ColorIndex = 35
End If

End If

End Sub



"bell7526" wrote:

How do I get the cell to highlight or letters to change color when someone
changes the content in a cell. Example is I want to have a formula in a cell
that is a projection and if someone types a plain number over top it to
adjust the project I want it to highlight. so if the formula calculates 75
and they want 100 they just key it over the formula and the cell will
highlight that there was a change. Can someone help me?
--
Billy Bellamy

  #3   Report Post  
bell7526
 
Posts: n/a
Default

Do I have to put that in visual basic or is there another way to enter it as
a formula?
--
Billy Bellamy


"TomHinkle" wrote:

That's Funny!!
I actually JUST wrote the exact same function about a week ago!! I was
afraid the user might forget they overwrote a cell..

Put this code in the worksheet_change event of the worksheet your data is in..

Private Sub Worksheet_Change(ByVal Target As Range)

' All this if does, is limit the color change to a specific region of the
worksheet
If ((Target.Column() 39) And (Target.Row() 1)) Then

If Target.HasFormula Then
Target.Interior.ColorIndex = xlNone
Else
Target.Interior.ColorIndex = 35
End If

End If

End Sub



"bell7526" wrote:

How do I get the cell to highlight or letters to change color when someone
changes the content in a cell. Example is I want to have a formula in a cell
that is a projection and if someone types a plain number over top it to
adjust the project I want it to highlight. so if the formula calculates 75
and they want 100 they just key it over the formula and the cell will
highlight that there was a change. Can someone help me?
--
Billy Bellamy

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formating Roy Excel Discussion (Misc queries) 4 May 27th 05 02:16 AM
Help using Conditional Formating of Entire Rows [email protected] Excel Worksheet Functions 4 February 16th 05 05:29 PM
more than 3 conditional formating in excel Manan Excel Discussion (Misc queries) 2 February 7th 05 10:12 PM
Conditional Formating when result is text Lary Excel Worksheet Functions 1 December 16th 04 03:13 AM
30 Day Aging Report Using Conditional Formating Tiegris Excel Worksheet Functions 0 November 4th 04 11:07 PM


All times are GMT +1. The time now is 12:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"