| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
IF Function with formatting condition
I need a formula that will do the following:
if the sum of j10/h10 is less than 50 then put the answer in red and bold. Thanks in advance to anyone who can help me. |
|
#2
|
|||
|
|||
|
You can use conditional formatting under the Format menu. Just select the
cell/cells where you have that formula then select where cell value is less than or equal to 50 then select red as font or you can even choose a pattern or fill for the cell. Good luck "ABDIAZ" wrote: I need a formula that will do the following: if the sum of j10/h10 is less than 50 then put the answer in red and bold. Thanks in advance to anyone who can help me. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| clock | Excel Worksheet Functions | |||
| Need a ISWorkday Function -- Any Ideas | Excel Worksheet Functions | |||
| Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions | |||
| How can I use an IF function to look for specific cell formatting. | Excel Worksheet Functions | |||
| Conditional Formatting "OR" function | Excel Worksheet Functions | |||
Hybrid Mode
