How to excel in so do not automatically calculate scores
If A1 = 3, B1 = 21, C1 = A1/B1, how to make C1 show 3 / 21, and the format remains the number? In order to be able to form conditions for the application, thus corresponding to the cell to carry out the color mark?
Thank you!
to select those cells, the right to set the cell format, the number of points you can choose.cell will be set to score Format.
If the request is still 3 / 21, since the definition of the format:# # / 21
this is only a = A1 &”/”& B1.But this can also be used to the conditions set format Setting conditions, you talk about the conditions of the format is what conditions?
Condition format to choose the conditions formula for the formula:
= $ A1 / $ B1 <0.3
= AND ($ A1 / $ B1> = 0.3, $ A1 / $ B1 <= 0.5)
= $ A1 / $ B1> 0.5
Leave a Reply
You must be logged in to post a comment.