![]() Which will happen when any one of the cells in E5:E27 will have a value equal to or greater then the value in 元7. So, the background of 元7 is currently grey 20%, but when i meet the goal of squatting my bodyweight, i want the background to be lime green. "Formula is" "ISERROR(E5)" then selecting a style putting the font the same color as the background. So, many of the cells in E5:E27 currently have error messages, but i used conditional formatting to cause the error messages to be the same color as the background by selecting the cells, format/conditional formatting. ![]() Progress.E5:E27 have the formula =IF(Table.D10=0 na Table.D10) (the value in table.E3 is my bodyweight, 元7 is my goal for how much I can squat, M37 is =$Table.E3*1.3, which will be my next goal) ![]() Progress.元7 has the formula '=$Table.E3*1'
0 Comments
Leave a Reply. |