How to change row color by cell value

Closed
Devender - Aug 8, 2009 at 04:07 AM
 gg - Dec 24, 2009 at 09:50 AM
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.

2 responses

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
4
Awesome working great
0
You are true. But it satisfies only for three options
4