Enter a zero into a cell and format as date. (If you don’t see your rule, you may not have selected a. Click Conditional Formatting, then select Manage Rules. Place the cursor in any cell to which the conditional formatting rule applies. MONTH(41838) => 7, YEAR(41838) => 2014, DAY(41838) => 18 and you can use the DAYS function to subtract 2 numbers from each other because this is what it actually does.ĭay number zero in Calc is which is mostly compatible with Excel and one of its bugs. Using Excel Conditional Formatting Based on Another Column or Cell. Selection of the data range for conditional formatting. When you subtract 6 from 8 you get 1838 because you subtract day number 40000 from day number 41838 actually. Using Conditional Formatting to Highlight a Row To highlight an entire row, we use Conditional Formatting and enter a formula based on the required or given criteria. Any integer number can be formatted to be displayed as a date, any date can be formatted to be displayed as an integer number. In every respect they behave exactly like integer numbers. All dates in spreadsheets are day numbers. Subtracting 2 day numbers from each other does the same. When I tried 07/18/14 as Requested Date and 07/16/14 as Target Date, my Overdue date was 185.įormula seems fine (today-target date). I have tried both multiple conditions per cell and one condition per cell (keeping the Range of Cells constant for that cell) but still have the same problem. JustANoob wrote:Ville, I got way-off overdue dates when trying the formula you posted. The problem I have is: IF the referenced cells are not blank AND have another conditional format style set, they do not change to the new one.
0 kommentar(er)
