Hello, how can I copy and paste Conditional formatting rules when the dates differ? It always uses the first date on first rule in row 1.

asked 2018-10-29 06:22:40 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

October 13, 2017 January 13, 2018 29 October 2018 November 6, 2017 February 6, 2018 29 October 2018

edit retag flag offensive close merge delete



@Jenner_uk: To ask a good question, you should provide information in a form that is clear and precise, so that others could understand. E.g., "I have "this" in A1, "that" in A2; and I use "XYZ" conditional formatting with "some" formula; and I get this unintended result, instead of this intended". Or better "Here is my sample file with sample data and here is clear description of the problem as above"...

Mike Kaganski gravatar imageMike Kaganski ( 2018-10-29 07:49:24 +0100 )edit