Plese, help me to change background of rows 2 to 10 based on first row value. I have columns A to J.
If the value on the first row of certain column contains certain value so the cells of row 2 to 10 change to red. I hope there are some formulas to change it automatically from Conditional Formatting.
Bookmarks