how to change the color of excel by using equal sign?

Question

how to change the color of excel by using equal sign?

which means, if i typed B1 with 1000, and changed color to red

and then in cell A1, i typed =B1, but the strange thing happened, A1 showed 100 but the color did not change to the B1's format (which is color red) and still remain the default color black

how can i make the A1's format equivalent to exactly as B1

dont tell me to change the cell color to red in A1, that is not the answer i want, i want to know, how to just using the equal sign, to get exactly formating from B1

thank you : )

Answer 1

This is not a formatting with = sign. It is done with Conditional formatting. Follow the steps to access the conditional formatting dialog box

- Open Excel
- Select the cell or cells you want to format
- Then click Format -> Conditional Formatting …
- Build the condition you need with the dialog box
- Press the “Format” button to change the format of the cell as you need
- Then press OK

Note – Only 3 maximum conditional formatting are possible per one cell. You can use the “Add” button to add new conditions or the previous conditions may get override.

Answer 2

That's conditional formatting. Click on the cell then on the Format Menu, Conditional Formatting...
IF (Argument)>999 or IF (Argument)=100
Then click the Format button to change colours etc.