Color
How do you display a certain color in a cell for a formula for example in the
formula = IF C4-C50 than display "Order", but display cell in red but in same cell = IF C4-C5<0 than display "No Order", but display in Green I know it is confusing but how do I do this? |
Color
Use conditional formatting on format menu for change color as you want.
use this formula in condition formatting for C4-C5 0 =C4C5 and use this formula in conditional formatting for C4-C5 < 0 in condition2 =C4<C5 "Justin" wrote: How do you display a certain color in a cell for a formula for example in the formula = IF C4-C50 than display "Order", but display cell in red but in same cell = IF C4-C5<0 than display "No Order", but display in Green I know it is confusing but how do I do this? |
All times are GMT +1. The time now is 02:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com