We need to enter lots of data in a excel sheet. Later we want to color code that data.
I will be the one preparing this excel sheet and sharing with team. What I want is the moment I put a number and if it is not falling in range, cell will turn red else green i.e. I don't want to go through cells again and color code them.
I found if formula
Here I have two problems,
C3should be direct input means I don't want to apply this formula on someother column.
- I don't know the formula to color a cell if condition is not true/false.