Only top left cell in selection affected when using formula rule

Only top left cell in selection affected when using formula rule

Posted by: randy.nichols on 24 May 2019, 1:41 pm EST

• 

  randy.nichols

  • Post Options:
  • Link
    Copy

  Posted 24 May 2019, 1:41 pm EST

  If the range passed into the formula rule is more than one cell, only the top left cell is affected if the formula is true. Is that expected behavior?

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 27 May 2019, 4:39 am EST

  Hi Randy,

  I am sorry but I’m unable to fully understand the issue. Could you please explain the issue some more? Are you referring to conditional formats or data validation? Also please share some snippet of your implementation.

  Regards

• 

  randy.nichols

  • Post Options:
  • Link
    Copy

  Posted 27 May 2019, 11:30 am EST

  I was using the rule in an incorrect way. I apologize for the noise.

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 27 May 2019, 11:50 pm EST

  We are glad to hear that your issue has been resolved.