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
|
|||
|
|||
Thanks so much, it worked great. I think I was over-thinking it.
"jennifer" wrote: 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. |
#3
|
|||
|
|||
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 |