Apr 14 2020 02:05 AM
Hello,
I have a spreadsheet with 3,000 lines used for reviewing inventory.
I have a column that uses a simple formula =SUM(S14*1.19)/N14 this formula is used on all 3,000 lines
There is change about to take place that requires the calculation be *1.195 this change will be made to individual lines over several months. This there a way to use conditional formatting to change the cell colour when I change the formula against individual products
Thank you
Apr 14 2020 02:24 AM
Apr 15 2020 01:37 AM
@Jan Karel Pieterse Thank you very much. Solved my problem.....cheers