Cell Property Changes Based on Value of Other Cells

[erc1452]

I have seen this in spreadsheets before, but for the life of me cannot figure out how it is done.

How do you make a cells background color change, border change, text go bold, etc, based on the value of another cell?

Example: Cell A1 has a white background, but when the value of Cell B1 is greater than 4, the border of Cell A1 becomes Yellow.

 

[Mudface]

You need to use either Conditional Formatting or a macro to do this. For your example, select cell A1, click on Format-Conditional Formatting and change the dropddown from 'Cell Value Is' to 'Formula Is'. Enter the following formula: -

=B1>4

Then click on the Format button and select your format. Do a search on the site for conditional formatting for many other examples, both simple and complex.