Hi, I'd like to format cells dynamically with background colors based on the numbers in the cell. Below is a basic example of what I am working with (mine is much more complex). So I would want all the "fast" numbers from sheet 2 (A1:A3) to be green, "medium" (A4:A6) yellow, and "slow" (A7:A10) to be red. I know how to conditionally format, but I'm wondering if there's a formula I can set for CF Format only cells that contain... cell value equal to _________ that can dynamically change the background colors based on my second table.
sheet 1
<tbody>
</tbody>
sheet 2
<tbody>
</tbody>
Thanks for your help
sheet 1
2 | 5 | 9 |
4 | 9 | 1 |
4 | 8 | 3 |
<tbody>
</tbody>
sheet 2
1 | fast |
3 | fast |
8 | fast |
2 | medium |
4 | medium |
9 | medium |
7 | slow |
5 | slow |
6 | slow |
10 | slow |
<tbody>
</tbody>
Thanks for your help