Hi guys,
I am trying to create a conditional formula based on another cell's value.
If user inputs "No" into D11, I want E11 to change color to gray and put a dash in that cell.
I have tried writing standard IF function in conditional formatting using IF(D11="No","-"), but that just changed the cell to white with no dash.
I also tried using conditional formula D11="No" and also changing to custom number format by adding a dash as shown in Rules Manager below, but that only changes cell color to gray with no dash added.
I thought it was possible to do this with conditional formatting, but now I am not so sure.
If anyone knows how to do this with either conditional formatting or vba, it would be much appreciated!
I am trying to create a conditional formula based on another cell's value.
If user inputs "No" into D11, I want E11 to change color to gray and put a dash in that cell.
I have tried writing standard IF function in conditional formatting using IF(D11="No","-"), but that just changed the cell to white with no dash.
I also tried using conditional formula D11="No" and also changing to custom number format by adding a dash as shown in Rules Manager below, but that only changes cell color to gray with no dash added.
I thought it was possible to do this with conditional formatting, but now I am not so sure.
If anyone knows how to do this with either conditional formatting or vba, it would be much appreciated!