thanhvanchi
12-07-2016, 07:23 PM
Dear all member!
I was studying the application functions in Excel.
Currently I have a cell that says "number of cars:2".
I want to write something that makes it so that if the number of cars is less than 2, turn the cell red.
If it is greater than 2, turn the cell green.
Is there a way to reference just the number in the cell when writing an if statement.
If I can, how would I do so?
Thank's a lot!
I was studying the application functions in Excel.
Currently I have a cell that says "number of cars:2".
I want to write something that makes it so that if the number of cars is less than 2, turn the cell red.
If it is greater than 2, turn the cell green.
Is there a way to reference just the number in the cell when writing an if statement.
If I can, how would I do so?
Thank's a lot!