formatting
I don't want to colour the cell or change the font i want to multiply the
figure by 2 if it is between 0 and 100
"Totti" wrote:
On Nov 17, 12:43 pm, Chris wrote:
i am trying to put a format in excel of
if box A2 is between 0-100 then *2 or if it's between 101-200 then *3
Can anyone help please
Chris, your query is not very clear but in case you mean conditional
formatting, then just select the range of cells you want to be
formatted, and go to FORMAT CONDITIONAL FORMATTING there you will
find a wizard :
cell value | is between | (here you put "0") | (here you put "100")|
then press format and format the cell as you please, when you are done
with the first condition, click on "Add" and do the same for the
condition where cell is between 101 and 200 with another pattern i
suppose.
|