Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Conditional formatting using formulas

How do I use the Excel 2007 function Conditonal Formatting using a formula
to format the selected cells. For example, I have a row of data, say
B32:X32. The data in this row must either be 15% or 12.5%. How do I make
any
other number show in bolded red %?


  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 320
Default Conditional formatting using formulas

With B32:X32 selected:
=AND(B32<.15,B32<.125)
then format it as you wish.
Bob Umlas
Excel MVP

"Murray" wrote:

How do I use the Excel 2007 function Conditonal Formatting using a formula
to format the selected cells. For example, I have a row of data, say
B32:X32. The data in this row must either be 15% or 12.5%. How do I make
any
other number show in bolded red %?


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
Conditional formatting using formulas Murray[_2_] Excel Discussion (Misc queries) 2 June 4th 08 04:04 PM
Conditional Formatting-No Formulas IvanM Excel Worksheet Functions 16 March 10th 08 09:23 PM
Conditional Formatting and If/Then Formulas Burntbiskit Excel Discussion (Misc queries) 2 January 3rd 07 01:56 AM
Conditional Formatting - Formulas meandmyhorse Excel Discussion (Misc queries) 2 February 18th 06 12:58 PM
Help Using Formulas in Conditional Formatting Still Learning Excel Discussion (Misc queries) 2 January 28th 05 04:55 PM


All times are GMT +1. The time now is 08:54 PM.

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"