Forum Discussion
Can you conditional format a cell based on the color of other cells?
Can you conditionally format (color a cell) based off of the conditional formatting (color) of another cell in an array? For example. In column A I have samples A3:A100 I subject Sample A3 to a ...
It would have been useful to have a sample workbook rather than having to reconstruct a version from your description. I read the description in exactly the same way as HansVogelaar . For me, using Excel 365, it make little difference other than adjusting the bounds UBound and LBound to be arrays rather than scalars. The Name 'violated' refers to
= LET(
sample, XLOOKUP(@ID, ID, Samples),
UBoundViolated, sample>UBound,
LBoundViolated, sample<LBound,
OR(UBoundViolated, LBoundViolated) )and provides the basis for a conditional format.