Forum Discussion

mgrivillas's avatar
mgrivillas
Copper Contributor
May 15, 2024

Help needed in Excel

I have a cell that changes their values when I enter a text in another cell. This are validations.

 

Cell L46 = Error - Please provide an explanation 

Cell E46 is blank

 

Then when I write an Explanation in Cell E46 

then 

Cell E46 = OK

 

Where I can see those conditions in my excel s/s.

I looked in conditional format but it's not there, there isn't a Macro in my s/s 

 

Can someone help?

 

Thanks 

excel
Formulas and Functions

3 Replies

    • mgrivillas's avatar
      mgrivillas
      Copper Contributor
      May 15, 2024
      No, there's already a formula there L46 based on another cell, then when I write a comment in E46 it's goes ok based on that cell.
      I checked also conditional formatting and Format object.

      Some how the cell are link similar to Format object.

      Thanks