Home |
Search |
Today's Posts |
#1
|
|||
|
|||
FORMULA TO MAKE CELL COLOR CONTINGENT
Is there a way to make the font/background color contingent on another cell?
We think we would use some type of "IF" analysis but ... For example, if cell B1 = 50 we want cell B6 to be red. Thanks! Patrick |
#2
|
|||
|
|||
You need Conditional Formatting. Look at 'Highlight cells that meet specific
conditions' in the Answer wizard -- HTH RP (remove nothere from the email address if mailing direct) "FORMULA QUESTION" <FORMULA wrote in message ... Is there a way to make the font/background color contingent on another cell? We think we would use some type of "IF" analysis but ... For example, if cell B1 = 50 we want cell B6 to be red. Thanks! Patrick |
#3
|
|||
|
|||
Use Conditional Formatting for this. Check out the Help Topic and this website:
http://www.contextures.com/xlCondFormat01.html tj "FORMULA QUESTION" wrote: Is there a way to make the font/background color contingent on another cell? We think we would use some type of "IF" analysis but ... For example, if cell B1 = 50 we want cell B6 to be red. Thanks! Patrick |
#4
|
|||
|
|||
Thanks, BUT I don't think conditional formating will let me do this. It will
let me format THAT cell based upon the condition, but I need it to format another cell. For example, one cell has a name. The other cell has a number. I want to set it up so that if the number cell is greater than 20 that the NAME cell has the font/background turn red. Thanks! "tjtjjtjt" wrote: Use Conditional Formatting for this. Check out the Help Topic and this website: http://www.contextures.com/xlCondFormat01.html tj "FORMULA QUESTION" wrote: Is there a way to make the font/background color contingent on another cell? We think we would use some type of "IF" analysis but ... For example, if cell B1 = 50 we want cell B6 to be red. Thanks! Patrick |
#5
|
|||
|
|||
Conditional Formatting will let you do this.
Check out the Help Topic Bob mentioned, or look at the website. Example: Select cell B6. Go to Format | Conditional Formatting. Then, pick Formula is and set the criteris to =B1=50. Be sure to capitalize the B as the Conditional Formatting box has a nasty tendency to interpret lowercase letters as text rather than cell references. tj "FORMULA QUESTION" wrote: Thanks, BUT I don't think conditional formating will let me do this. It will let me format THAT cell based upon the condition, but I need it to format another cell. For example, one cell has a name. The other cell has a number. I want to set it up so that if the number cell is greater than 20 that the NAME cell has the font/background turn red. Thanks! "tjtjjtjt" wrote: Use Conditional Formatting for this. Check out the Help Topic and this website: http://www.contextures.com/xlCondFormat01.html tj "FORMULA QUESTION" wrote: Is there a way to make the font/background color contingent on another cell? We think we would use some type of "IF" analysis but ... For example, if cell B1 = 50 we want cell B6 to be red. Thanks! Patrick |
#6
|
|||
|
|||
Just to endorse this statement, it will do what you want.
-- HTH RP (remove nothere from the email address if mailing direct) "tjtjjtjt" wrote in message ... Conditional Formatting will let you do this. Check out the Help Topic Bob mentioned, or look at the website. Example: Select cell B6. Go to Format | Conditional Formatting. Then, pick Formula is and set the criteris to =B1=50. Be sure to capitalize the B as the Conditional Formatting box has a nasty tendency to interpret lowercase letters as text rather than cell references. tj "FORMULA QUESTION" wrote: Thanks, BUT I don't think conditional formating will let me do this. It will let me format THAT cell based upon the condition, but I need it to format another cell. For example, one cell has a name. The other cell has a number. I want to set it up so that if the number cell is greater than 20 that the NAME cell has the font/background turn red. Thanks! "tjtjjtjt" wrote: Use Conditional Formatting for this. Check out the Help Topic and this website: http://www.contextures.com/xlCondFormat01.html tj "FORMULA QUESTION" wrote: Is there a way to make the font/background color contingent on another cell? We think we would use some type of "IF" analysis but ... For example, if cell B1 = 50 we want cell B6 to be red. Thanks! Patrick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula HELP | Excel Worksheet Functions | |||
Display answer only in another cell of one containing a formula | Excel Discussion (Misc queries) | |||
how do i make a cell date sensitive to execute a formula or input. | Excel Discussion (Misc queries) | |||
looking for a formula | Excel Worksheet Functions | |||
make a cell empty based on condition | Charts and Charting in Excel |