In a sheet of a Sheet doc, I would like to use conditional formatting :

Which applies to my sheet1, range E8: UH49 Custom formula: = OR (COUNTIF (Holiday1; E5); COUNTIF(Holiday2; E5)) With Holiday1 and Holiday2 being named ranges in another sheet (sheet2 ) I tried with range name, and with the reference to the sheet name sheet2! ... the formula doesn't tell me anything invalid, but the conditional formatting doesn't work.

Do you have an idea?


1 Answer 1


Conditional Formatting custom formula requires that the references be on the same sheet. To grab values from other sheets you could use INDIRECT.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.