Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need the result after using formula in deffrent colour
i am using microsoft excel version 2003 how to discribe in formula to get
answer in diffrent colour examples are as under 1- when days are exceeding 100 i need in read colour equal to and less then 100 need the result in black colour Condition =now()"28-06-2006" - 01-01-2006 = 178 days ( need 178 result automaticaly in read colour bcz its grater then 100) Condition =now()"28-06-2006" - 01-06-2006 = 27 days ( Need 27 result automaticaly in black colour bcz its = & less then 100) We are looking forward to your great support. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need the result after using formula in deffrent colour
Assuming your formula work in the cell then go to format_conditional formating choose cell value 100 pattern red Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=556338 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The Formula is displaying, not the result | Excel Discussion (Misc queries) | |||
Rs.10,250.00 formula Rupees ten thousand two hundred fifty only | New Users to Excel | |||
How do I make a formula read a result rather than a formula | Excel Discussion (Misc queries) | |||
Formula Showing In A Cell Instead of Proper Result | New Users to Excel | |||
Median result used in formula gives incorrect result | Excel Worksheet Functions |