Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
change cell color within a formula...
I have this formula working in me Excel document
=IF(A1=39295; "OK"; "Not OK") It works! It is a big deal for i´m not a programmer! But what I need, instead of "OK" and "NOT OK" is to change the cell color. OK - black #000000 NOT OK = orange #FF6600 Is this possible? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
change cell color within a formula...
Take a look at Format|Conditional formatting.
You can specify up to 3 conditions (in xl2003 and below) and specify the colors/formatting that you like. rdeap wrote: I have this formula working in me Excel document =IF(A1=39295; "OK"; "Not OK") It works! It is a big deal for i´m not a programmer! But what I need, instead of "OK" and "NOT OK" is to change the cell color. OK - black #000000 NOT OK = orange #FF6600 Is this possible? Thanks. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
change cell color within a formula...
Look in Excel help for "conditional formatting".
-- David Biddulph "rdeap" wrote in message ... I have this formula working in me Excel document =IF(A1=39295; "OK"; "Not OK") It works! It is a big deal for i´m not a programmer! But what I need, instead of "OK" and "NOT OK" is to change the cell color. OK - black #000000 NOT OK = orange #FF6600 Is this possible? Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
change cell color within a formula...
Thanks but it didnt work. Its difficult to me.
I´m using Office2007. I found the conditional format but I dont know how to use it. It goes all wrong... /////////////////////////////////// What im tryng to do is to highlight a cell that represents 'today'. i have H1 to AK1 to change the color (it representes the 30 days for august) the idea is: today is orange not today is black. /////////////////////////////////// in A1 i have today() today 8/8 is 39302 in H1 (that represents 01/08/2007 / 39295) i have: =IF(A1=39295; "OK"; "Not OK") in each cell that i want to color, i have a number that represents its day for august, it goes from 39295 to 9332a (01/08 - 30/08) Maybe its not this way, isnt it? For what i looked at the conditional format I could not use my formula... But thanks anyway //////////////////////////////////// |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
change cell color within a formula...
I did it. Thanks!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Formula to change cell color | Excel Discussion (Misc queries) | |||
Change font/cell color by Formula | Excel Worksheet Functions | |||
Change color in cell if contains formula? | Excel Discussion (Misc queries) | |||
Cell color change in formula | Excel Worksheet Functions | |||
How do I create formula to change cell color | Excel Worksheet Functions |