Hi,
I am preparing a textile worksheet where i have to enter the required and achieved bed sheet sizes.
For Example
Cell A1 = 140 x 200 ( This is the required bed sheet size ) Width x Length
Cell A2 = 141 x 200 ( This is the achieved bed sheet size) Width x Length
the achieved size differs from the required size by 1CM
Is there any formula where it can change the color of only that part of cell A2 which does not match with cell A1. I mean format only the part of the string which does not match and not the entire cell
Thanks
I am preparing a textile worksheet where i have to enter the required and achieved bed sheet sizes.
For Example
Cell A1 = 140 x 200 ( This is the required bed sheet size ) Width x Length
Cell A2 = 141 x 200 ( This is the achieved bed sheet size) Width x Length
the achieved size differs from the required size by 1CM
Is there any formula where it can change the color of only that part of cell A2 which does not match with cell A1. I mean format only the part of the string which does not match and not the entire cell
Thanks