Forum Discussion
nlangbo
Jul 27, 2020Copper Contributor
Conditional Formatting for Schedule
Hello, I was wondering if someone could help me with a query for my excel spreadsheet I use for school. I am switching from Google Sheets to Excel and I had a conditional formatting formula set up to...
nlangbo
Jul 27, 2020Copper Contributor
Also, I am not sure where to edit the color scheme of the formulas? I see how to manage the formatting but not how to edit it. If I had separate groups of cells where it is currently merged, would i just use the same formula? Bennadeau
Bennadeau
Jul 27, 2020Iron Contributor
To change the color, select the entire schedule and follow the arrows in the screenshot attached. You will have to do this for every single conditional formatting one at the time.
Attached is the workbook with the second sheet completed.