Condtional formating is broken/changed when adding rows
Hi, My use of conditional formating works, but it is not otpimal. I wish it could be easier to use for the end user, to avoid errors and mistakes. (Second attempt, simplified version) The Scenario: 1 Table with a set of tasks. If I find a specified word in that table, i would like to change the color in my second table. Original setup. Everything is fine: Deleting a line in my table. Conditional formating rules is rebuild. And the colors is moved up by a line. No longer matching the ID in the formula give. Adding a new row, Now the colored cells is pushed down a line. So Wrong persoon is colored. I cant understand the Reason for adding more conditions, instead of just change the area for the condition. So, is there a better solutions for this? Best Regards - Geir
Conditional LIne/Border insetion
Task: to watch changes in column numbers Objective: If number increases from previous row then add border of one color (Green) If number decreases from previous then add border of another color (Red) Format: Through out one section of a spreadsheet. Comments: I've looked at conditional formatting and it only 'seems' to work on cell by cell conditioning. Where I need several hundred cells considered (top to bottom) and marked. Can this be done. and how is this done if it is possible?Conditional Formartting
So i have a cell that i'm putting the date of when someone last completed an exam that has to be done every 30 days. It already has one rule to be shaded red if the cell is blank. Now i want tye date that's entered to be red if it has been 30 days or more from the last completed exam and then blue if it's been 29 days or less. I was trying to use the formula =$I2-TODAY()‹=29 and =$I2-TODAY()›=30 but it's not working for me.
