Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting using formulas | Excel Discussion (Misc queries) | |||
Conditional Formatting-No Formulas | Excel Worksheet Functions | |||
Conditional Formatting and If/Then Formulas | Excel Discussion (Misc queries) | |||
Conditional Formatting - Formulas | Excel Discussion (Misc queries) | |||
Help Using Formulas in Conditional Formatting | Excel Discussion (Misc queries) |