I need help with conditional formatting:
I have two sheets and I need the formatting to take place on the second sheet ("Floor"). Here's the problem. I need the formatting to be the same as in column C (Oddelek) but the formatting may only occur if there is a value entered in column "E" of the first sheet ("Pupils"). The formatting must apply to a cell with the corresponding value. For example: If I enter a value 287 in column E, the formatting should be the same as in column C (blue), but in the cell with the value "287" on the "Floor" sheet.
Bookmarks