Conditional formatting across sheets

[djcfisher]

Hi, I'm trying to apply conditional formatting to cells on one sheet based on values on another, as replicated in the attached example. I'd like to make the text on sheet 2 grey when there are values in the corresponding cells on sheet 1; when the cells on sheet 1 are blank, I'd like the text in sheet 2 to remain black. Is there a way of doing this? Thanks very muchExample sheet.xlsx

[K m]

Since Conditional formatting does not work between sheets, you could have a hidden column in Sheet 2 that has a formula like: +Sheet1!A1 {formula would be copied down}.

That way you could base the conditional format on the values in the hidden column

[djcfisher]

OK thanks, useful to know that conditional formatting doesn't work between sheets. Have created a hidden column as you suggest. Unlike the example I sent, my real 'Sheet 2' has multiple columns and multiple rows (rows 1-100 and columns A-H, where H is the new hidden column). I'd like to 'grey out' all text in the rows where the value in column H is greater than zero. Excuse my ignorance about conditional formatting, but grateful if you could explain how to do this. Thanks.

[K m]

Go to the cell that has the conditional format:
- Right click COPY
- Hightlight the entire row you want the conditional format to apply to
- Right click PASTE SPECIAL
- Choose PASTE FORMATS
- Choose OK

This copys the conditional format to the entire row

If this answers your question click on the star at the bottom of this reply and indicate that the problem is solved