conditional formatting adjacent cells based on cell in middle

Copper Contributor

TudorHH3000_0-1713206457903.png

i have this school project and i made the conditional formatting for the middle cell but i do not know how to make the left and right adjacent cells match. i have to have this page as a grid consisting of 50x50px cells and i cannot figure out how to make this work. the cells adjacent to "in asteptare" should have the same colour as the middle cell that contains the centered text.

1 Reply

@TudorHH3000

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?