![]() |
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 %? |
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