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 tried:
I found if formula =if(200<C3<500,[value_if_true],[value_if_false])
Here I have two problems,
C3
should 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.