This topic contains 0 replies, has 1 voice, and was last updated by papa 12 years, 2 months ago.
Viewing 1 post (of 1 total)
Viewing 1 post (of 1 total)
You must be logged in to reply to this topic.
Home › Forums › Tech › Office and Applications › How to Apply Row Conditional Formatting in Excel
Tagged: Color, Column, Conditional, Formatting, Range, Row
This topic contains 0 replies, has 1 voice, and was last updated by papa 12 years, 2 months ago.
Ok. Ladies and gentlemen. In Excel you have a “driver” column that has a limited number of values: marks, ranks, status and like. You need to color entire row based on the value in that column.
Conditional formatting is the answer.
This example:
– assumes your data starts from second row;
– uses column C as a “driver” column;
– add 2 conditions Less than 4 and Greater then 7.
-01- Highlight the entire range of cells that need coloring (it means all rows and all columns that will be included in coloring).
-02- Pick Conditional Formatting on Home tab, Styles section and pick New Rule.
-03- Pick the last option – Use formula to determine witch cells to format.
In the box “Format values where this formula is true” type this:
=IF($C2 < 4, 1,0)=1
Note: This formula is satisfied and evaluates to true, when value in your “driver” column “C” is less than 4. Missing dollar sign in fromt of 2 (in $c2) means that you want your condition to change for every row.
-04- Set fill format to pink
-05- Repeat the same steps for values greater than 7. Use formula:
=IF($C2 > 7, 1,0)=1
And set fill color to light green.
You are done! Just look at your magnificent work.
Note: if you need to set a rule for values between 4 and 7, use this more elaborate rule:
=IF($C2 > 3,IF($BC<7,1,0),0)=1
You must be logged in to reply to this topic.
Posted | Modified |
---|---|
Nov 16 | Dec 2 - 14:52 |
2017-11 - From the Editor - Who is My President?... | |
Nov 29 | Nov 26 - 14:21 |
Sat *WARREN* 09:00 - - - Sun *BROWN* 09:00... | |
Nov 26 | Nov 26 - 14:19 |
19 Game Results - 2017-11-26 SU - Diego dropped others - Andres scored 4... | |
Nov 24 | Nov 24 - 18:10 |
Adventures in the Dominican... | |
Oct 11 | Nov 17 - 20:32 |
Home... |
Rani S | Nov 15 |
Nice lesson, thank you for sharing with us :)... | |
Scottgal | Nov 4 |
Всем привет, уже третий день не могу поставить D... | |
useaglefcu.org | Jul 4 |
In MongoDB, is it possible to update the value of ... | |
Andre | Jun 24 |
Works with Server 2016 IIS 10.... |
|
Copyright © 2024
Domain Web Center . All Rights Reserved. Magazine Basic theme designed by Themes by bavotasan.com . Disclaimer | Powered by WordPress and bbPress. | Contact the Editor |