Search : in
By :

Cell colour change on changing cell value

Last answer on Aug 13, 2009 9:50:34 am BST invent, on Aug 12, 2009 7:15:43 am BST 
 Report this message to moderators

Hello,
How can i select the colour for a specific cell with reference of cell value change.
Suppose Cell value is greater then previous value show one colour and again the new value is low then previous value it show onther colour.

Can it be in Exchel Sheet or .........

Configuration: Windows XP Internet Explorer 6.0

Best answers for « cell colour change on changing cell value » in :
[VBA] Detecting changes in cell Show [VBA] Detecting changes in cell The Event Change feature of a sheet will detects the change in the active cell but it gives no information about the content. The example given below will help you to find out if the cell was changed,...
Changing cell colour through % differnce Show
How to make a cell change colour Show
Excel - Send value of cell to target ShowExcel - Send value of cell to target Issue Solution Note Issue Is it possible to send the value of a cell (copy and paste special) to another cell where the value would not be disturbed when the source value changes to '0'? My...
[Excel]changing cell formula to text Show[Excel]changing cell formula to text Issue Solution Notes Issue Consider that I have: In cell A4, it contains a formula =Sum(A1:B3)+A3/B2. How to extract this formula in cell A6 as a string of text? That is ... I want cell A6...
VB6 Finding the RGB values of a color ShowVB6 Finding the RGB values of a color Dim R as integer Dim G as integer Dim B as integer Sub FindRGB(Col As Long) R = &HFF& And Col G = (&HFF00& And Col ) \ 256 B = (&HFF0000 And Col ) \ 65536 End Sub Note: Here...
CMYK (CMJN) Coding ShowCMY Coding CMY Coding (Cyan, Magenta, Yellow) is to subtractive synthesis, what RGB coding is to additive synthesis. This model consists in breaking up a colour into values of Cyan, Magenta and Yellow. The absence of these three components yields...
Environment variables ShowEnvironment variables An environment variable is a dynamic value loaded into the memory that can be used by several processes operating simultaneously. On most operating systems, the location of some libraries or of the main system executables may...
Spreadsheet - Formulas ShowIntroduction to Formulas The main use of a spreadsheet is to automate calculations, which means using cells to perform operations based on values in other cells. The spreadsheet recalculates all the values each time a change is made to the value of...
Ask your question Reply

1

kaiyasit, on Aug 12, 2009 11:04:31 am BST

Use ConditionFormating by

On menu bar click
1.Format
2.Condition Formatting
you will see.....2 types that is
1.Cell Value is
2. Formula is

Please try...........

Best regards,
Kaiyasit Phanmakorn
kaiyasitp@gmail.com

   
Reply to kaiyasit

2

change, on Aug 13, 2009 9:03:19 am BST

Boss,

I tried it. But I want colour change of the same cell. If value change of it. Suppose A4 has value 4 & after few second it change 5. What formula I have to fit there.

   
Reply to change

3

 kaiyasit, on Aug 13, 2009 9:50:34 am BST

Try to use "Sub Worksheet_Change(ByVal Target As Range)"

and write VBA code to control when value change.

Do you have file example?

best regards,
Kaiyasit Phanmakorn
kaiyasitp@gmail.com

   
Reply to kaiyasit
Ask your question Reply
They need your help