Hello,
I need 2 conditional formatting rules:
1. if 1 cell value in row is let's say "xyz" format the whole cells in the row to be red (the text)
2. if 1 cell value in a column is "xyz" format the whole cells in the column to pe green (the cell fill).
Thank you very much