Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15
Default 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..


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,872
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2010 Conditional Formatting rjbabbidg Excel Worksheet Functions 2 February 27th 13 09:00 AM
alternate rowshading using conditional format excel 2007/2010 Ludo Excel Programming 6 July 16th 12 05:10 PM
Conditional Formatting in Excel 2010 is being removed when I emailExcel Workbook [email protected] Excel Programming 0 April 25th 12 09:59 PM
Help with conditional formatting in Excel 2010 Ian R[_4_] Excel Worksheet Functions 8 February 14th 12 02:08 AM
little off topic, but with excel 2010 conditional formatting properties will be accessible through vb Gary Keramidas Excel Programming 0 August 14th 09 03:46 PM


All times are GMT +1. The time now is 11:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"