Hi,
I would like to add condtional formattin by way of Color Scaels to cells B1:G10 of the image/spreadsheet below. Is there a way conditional formatting can be used on the last two numbers of a cell as in B1:G10?
Or, I have put the RIGHT fomrula in Cells I1:N10, to look at the last twp characters of Cells B1:G10. This is how I would like Cells B1:G10 conditionally formatted. Can I use the values in Cells I1:N10 to condtionally format Cells B1:G10?
Thanks for any help.
James
I would like to add condtional formattin by way of Color Scaels to cells B1:G10 of the image/spreadsheet below. Is there a way conditional formatting can be used on the last two numbers of a cell as in B1:G10?
Or, I have put the RIGHT fomrula in Cells I1:N10, to look at the last twp characters of Cells B1:G10. This is how I would like Cells B1:G10 conditionally formatted. Can I use the values in Cells I1:N10 to condtionally format Cells B1:G10?
Thanks for any help.
James