ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Conditional formatting using formulas (https://www.excelbanter.com/excel-discussion-misc-queries/189945-conditional-formatting-using-formulas.html)

Murray[_2_]

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 %?



Bob Umlas, Excel MVP

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 %?




All times are GMT +1. The time now is 02:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com