Search : in
By :

How to change row color by cell value

Last answer on Aug 25, 2009 9:15:47 am BST Devender, on Aug 8, 2009 9:07:38 am BST 
 Report this message to moderators

Hello,

Dear I want to know that how can row color be changed by it's cell value. Please explain with data in excel sheet.

Configuration: Windows XP
Firefox 2.0.0.20

Best answers for « how to change row color by cell value » in :
Changing the color of the command prompt(shell) ShowChanging the color of the command prompt(shell) Purpose Methods Purpose Changing the color of characters in the prompt (or shell), make them more readable. If you are using colors group, you can sense by color, this will eliminate the...
[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,...
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...
Ask your question Reply

1

Guy, on Aug 10, 2009 8:17:28 am BST

1.Select Rows that you need to do
2.At menubar click Format -> Conditional Formatsetting
3. At condition1 select "Formula Is"
4.type "=($A6<0)"
5.Click Format
6.Select Tab "Patterns"
7. Select your color
8. Click "OK"

****** in item 4 , you can change to cell as you require...........

this maybe help you......

Kaiyasit Phanmakorn

   
Reply to Guy

2

 fas, on Aug 25, 2009 9:15:47 am BST
  • +1

You are true. But it satisfies only for three options

   
Reply to fas
Ask your question Reply
They need your help