Changing background color based on different cell
I want the background color of cell A1 to change dependant upon whether anything has been entered into cell B1. How would I go about doing this? Thanks in advance! :) -- djarcadian ------------------------------------------------------------------------ djarcadian's Profile: http://www.excelforum.com/member.php...o&userid=15877 View this thread: http://www.excelforum.com/showthread...hreadid=570508 |
Changing background color based on different cell
Use Conditional Formatting with "Formula is": =$B$1<"" (rather than
"Cell value is") Regards Trevor "djarcadian" wrote in message ... I want the background color of cell A1 to change dependant upon whether anything has been entered into cell B1. How would I go about doing this? Thanks in advance! :) -- djarcadian ------------------------------------------------------------------------ djarcadian's Profile: http://www.excelforum.com/member.php...o&userid=15877 View this thread: http://www.excelforum.com/showthread...hreadid=570508 |
Changing background color based on different cell
djarcadian wrote: I want the background color of cell A1 to change dependant upon whether anything has been entered into cell B1. How would I go about doing this? Thanks in advance! :) -- djarcadian ------------------------------------------------------------------------ djarcadian's Profile: http://www.excelforum.com/member.php...o&userid=15877 View this thread: http://www.excelforum.com/showthread...hreadid=570508 Select the cell A1 then Select: FORMAT...CONDITIONAL FORMATTING...Select "Formula Is" from the dropdown to the left and enter the following formula in the entry area to the right: =$B$1<"" Now depress the FORMAT button and choose the background color of your choice and you should be set. |
Changing background color based on different cell
Thanks guys! Worked perfectly! -- djarcadian ------------------------------------------------------------------------ djarcadian's Profile: http://www.excelforum.com/member.php...o&userid=15877 View this thread: http://www.excelforum.com/showthread...hreadid=570508 |
All times are GMT +1. The time now is 06:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com