Cómo resaltar celdas con diferentes colores si se ingresan datos específicos expresados en KG en estas celdas
publicado
Hello everyone my name is Maurizio and first of all I would like to make you mine
most sincere wishes for a Happy New Year; Since for business reasons not
I managed to get them first.
That said, my new problem is this.
on an Excel sheet in the column (B3: B200) I have entered measurements of Specific Weight; Such as "125.3 Kg" Or "94.2 Kg" etc ...!
On the other hand, in the row that goes from (i1: n1) I have entered specific data; Such as: (95.0 Kg). (90.0 Kg).
(85.0 Kg). (80.0 Kg). (75.0 Kg). (70.0 Kg)
as Maximum reachable roof.
Now my question is this:
Is it possible to highlight the cells ranging from (I1: N1) in a different color if the weight entered in the Column (B3: B200) is close to the threshold of those figures entered in the Rows (I1: N1) even though they do not coincide perfectly?
Practical Example: If I write in column (B) "72.4 kg" and in Cell (N1) the figure of (70.0 kg) is reported, it goes without saying that the two amounts do not coincide perfectly!
But my request is right in this, that is to highlight the Cell (B1) in any case as it is the number inserted in column (B) closest to it
Otherwise: That is, that these numbers are greater than (96 Kg) the base color must remain unchanged, that's all!
I of mine have written down some solution, but it is not complete-
Some of you would be able to give me a hand on this thanks.
Affectionate greetings to all from A.Maurizio
Hello everyone my name is Maurizio and first of all I would like to make you mine
most sincere wishes for a Happy New Year; Since for business reasons not
I managed to get them first.
That said, my new problem is this.
on an Excel sheet in the column (B3: B200) I have entered measurements of Specific Weight; Such as "125.3 Kg" Or "94.2 Kg" etc ...!
On the other hand, in the row that goes from (i1: n1) I have entered specific data; Such as: (95.0 Kg). (90.0 Kg).
(85.0 Kg). (80.0 Kg). (75.0 Kg). (70.0 Kg)
as Maximum reachable roof.
Now my question is this:
Is it possible to highlight the cells ranging from (I1: N1) in a different color if the weight entered in the Column (B3: B200) is close to the threshold of those figures entered in the Rows (I1: N1) even though they do not coincide perfectly?
Practical Example: If I write in column (B) "72.4 kg" and in Cell (N1) the figure of (70.0 kg) is reported, it goes without saying that the two amounts do not coincide perfectly!
But my request is right in this, that is to highlight the Cell (B1) in any case as it is the number inserted in column (B) closest to it
Otherwise: That is, that these numbers are greater than (96 Kg) the base color must remain unchanged, that's all!
I of mine have written down some solution, but it is not complete-
Some of you would be able to give me a hand on this thanks.
Affectionate greetings to all from A.Maurizio
Valuta_Peso_Raggiunto.xlsm