Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add color or picture to a cell using a formula
How can you use colors as a result in a formula, i.e. color a cell red when
30 days from due date, color green when task accomplished. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add color or picture to a cell using a formula
Hi,
For example, I suggest you input a date in A1 as a due date, then go to "Format -- Conditional Formatting -- choose Formula Is in condition 1 -- type =NOW()-A130 -- choose format button -- select Pattern tab -- choose colour red -- OK -- OK. So, if today's date is more than 30 days the date in A1, the cell will change to colour red. The same procedure applies to your second question if you input "Y" in A1 for accomplished task. HTH "mckairborne" wrote: How can you use colors as a result in a formula, i.e. color a cell red when 30 days from due date, color green when task accomplished. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add color or picture to a cell using a formula
See http://xldynamic.com/source/xld.CF.html
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "mckairborne" wrote in message ... How can you use colors as a result in a formula, i.e. color a cell red when 30 days from due date, color green when task accomplished. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible? | Excel Worksheet Functions | |||
assign formula to another cell | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel |