Ask Your Question

conditional format : each row each cell

asked 2017-02-13 22:51:40 +0200

JG101 gravatar image

How do I create Conditional Formatting – (individual rows)to color code each cell: If cell is Less than prev cell = light RED or if cell is Greater than prev cell = light Green how can I write this for each Row / cell ?

also how do I copy conditional format and implement into row:cell without overriding data in cell. Or do I need to implement formula conditional format before entering data into cell.

thank you in advance

see document conditional format each row each cell 02-13-2017.ods

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-02-14 00:09:07 +0200

updated 2017-02-14 00:21:41 +0200

  1. To create the conditional formatting you need:

    a. Select e.g. C6, then Format->Conditional Formatting->Condition...

    b. Cell value is - greater than - D6 - Apply style - New Style... -> create a style with green background.

    c. Add -> Cell value is - less than - D6 - Apply style - New Style... -> create a style with red background.

    The above has created conditional formatting dependent on value of previous cell.

  2. To apply this to required range: at the bottom of the dialog (that we haven't closed yet) is Cell Range area; press Shrink button and select the area you need. Then Expand and press OK.

    This copies the formatting, and automatically makes it to depend on previous cell value.

edit flag offensive delete link more


Perfect THANK YOU!

JG101 gravatar imageJG101 ( 2017-02-15 21:57:58 +0200 )edit

answered 2017-02-14 00:35:51 +0200

karolus gravatar image

Select B7:N40 and define two conditions:

  1. Cell value … less than … B6 your red Style
  2. Cell value … greater than … B6 your green Style
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-02-13 22:51:40 +0200

Seen: 315 times

Last updated: Feb 14 '17