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.