Conditional Formatting - Multi-Cell Conditions

Conditional Formatting - Multi-Cell Conditions

Posted by: penigark on 25 February 2025, 10:13 pm EST

• 

  penigark

  • Post Options:
  • Link
    Copy

  Posted 25 February 2025, 10:13 pm EST - Updated 25 February 2025, 10:18 pm EST

  How do I implement conditional formatting based on the values of multiple cells?

  Please see the attached example.

  

  853×386 18 KB

• 

  aastha.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 28 February 2025, 3:30 am EST - Updated 28 February 2025, 3:35 am EST

  Hi,

  You can apply conditional formatting on multi-cell-conditions similar to MS Excel. The following GIF shows how to achieve this using the FpSpread’s RibbonBar control:

  

  We have also attached the sample application for reference. See MultipleCellCondition.zip

  For more information on cell conditional formation, check here: https://developer.mescius.com/spreadnet/docs/latest/online-win/spwin-interact-condition.html

  Thanks & regards,
  
  Aastha

• 

  penigark

  • Post Options:
  • Link
    Copy

  Posted 6 March 2025, 7:03 pm EST

  What would be the appropriate conditional formatting rule class to use in the specified case?

  Using an “AND” function where the first condition checks a value and the second checks text.

• 

  aastha.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 10 March 2025, 8:04 am EST

  Hi,

  Thanks for reaching out to us.

  Unfortunately, we could not understand how you are trying to add an “AND” function for a cell, where the first condition checks a value and the second checks text. We kindly request you update the already attached “MultipleCellCondition.zip” file with some dataset and explain the required behavior.

  This will help us provide you with a more specific solution.

  Thanks & regards,
  
  Aastha