Attached is a workbook that has cell V19 functioning as I want it to. There is Conditional Formatting on the cell that says if the sum in O19 - P19 is less than or equal to zero, and if the value in V19 is greater than 20000000, then turn the cell red and change the font to red. You can see that the conditional formatting is working for cell V19.
I now need to get that same conditional formatting to work dynamically for all of the cells above it in rows 2-18.
I also need to know how to get it to work if I insert any rows above the blue line in row 20. The conditional formatting is not dynamic even if I use Copy on row 19 and Insert Copied Cells above the blue line anywhere.
Any help is appreciated. Thanks.Conditional Formatting help.xlsx
Bookmarks