Feb 13 2019 02:14 PM
Hi I am using a number of rules in excel here is my example, box M5 has a date written in it, Box N5 has a formula to generate a date in 7 days time to remind me to send an email. N5 has conditional formatting to be green amber, red. I have copied and paste this down both columns so rules and formatting apply. I have column P which is formatted to a yes no drop down. I have managed to make N5 change to purple when P5 changes to yes. If I change the drop down box in P5 to no N5 stays the date color. When I try and paste that rule down all the boxes in column N go off box P5 instead of the box opposite it in Column P. I.e N8 will be purple even though P8 says no. If I change P5 to no all boxes in column N change back to date colors. Is there a way to copy and paste this rule so I dont have to individually do it by box.
Feb 14 2019 08:28 AM
SolutionFeb 14 2019 03:00 PM
Hi Ed, you may not have understood but you totally gave me the answer I think because I was putting the dollar sign before the number was limiting it to one cell, so removed it and I can now copy and paste away. Thank you!
Feb 14 2019 08:28 AM
Solution