CONDITIONAL FORMATTING IN EXCEL 2010
Sorry, this is obviously a really simply one, but the help comments are not
making sense to me! I wish to format A1 (background colour) when its value is higher than B1. As in:- A1 = 3.3% B1 = 2.8% so cell A1 background colour will change. Thanks for the help! Malcolm.. |
CONDITIONAL FORMATTING IN EXCEL 2010
Hi Malcom,
Am Thu, 16 May 2013 12:08:23 +0100 schrieb Malcolm Austin: I wish to format A1 (background colour) when its value is higher than B1. As in:- A1 = 3.3% B1 = 2.8% so cell A1 background colour will change. select A1 = Conditional Formating = New Rule = Use formula to determine which cells to format and enter the formula: =A1B1 and choose your expected format Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
All times are GMT +1. The time now is 06:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com