Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill a cell color using date in one cell and "yes/no" in another c
I want to use two different cells in a single row (one a date-formatted cell
& one a "Yes/No" text value cell) to display a cell fill color in a third cell - based on the conditions (e.g., date is <= today and text is "no" - filling third cell with red) present; How can I do this? Txs! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill a cell color using date in one cell and "yes/no" in another c
Try this...
A1 = some date B1 = yes or no C1 = fill with color if A1 = a date <=today and C1 = no Select cell C1 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the little box to the right: =AND(COUNT(A1),A1<=TODAY(),C1="no") Click the Format button Select the Patterns tab Select the color of your choice OK out -- Biff Microsoft Excel MVP "dinocm" wrote in message ... I want to use two different cells in a single row (one a date-formatted cell & one a "Yes/No" text value cell) to display a cell fill color in a third cell - based on the conditions (e.g., date is <= today and text is "no" - filling third cell with red) present; How can I do this? Txs! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill a cell color using date in one cell and "yes/no" in another c
Ooops! Typos!
C1 = fill with color if A1 = a date <=today and C1 = no =AND(COUNT(A1),A1<=TODAY(),C1="no") All references to C1 should be B1. -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Try this... A1 = some date B1 = yes or no C1 = fill with color if A1 = a date <=today and C1 = no Select cell C1 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the little box to the right: =AND(COUNT(A1),A1<=TODAY(),C1="no") Click the Format button Select the Patterns tab Select the color of your choice OK out -- Biff Microsoft Excel MVP "dinocm" wrote in message ... I want to use two different cells in a single row (one a date-formatted cell & one a "Yes/No" text value cell) to display a cell fill color in a third cell - based on the conditions (e.g., date is <= today and text is "no" - filling third cell with red) present; How can I do this? Txs! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill a cell color using date in one cell and "yes/no" in anoth
"T. VALKO" -
Below is the result I am trying to achieve: IF B$ IS <TODAY AND C$=NO, THEN FILL A$ AS RED; IF B$ IS =TODAY AND C$=NO, THEN FILL A$ AS GOLD; IF C$=YES, THEN FILL A$ AS GREEN; Condition ONE: Column A [cell] is filled RED when Column B [cell] entered date is before the current date AND Column C [cell] is NO; Condition TWO: Column A [cell] is filled GOLD when Column B [cell entered date is either the current or a future date AND Column C [cell] is NO; Condition THREE: Column A [cell] is filled GREEN when Column C [cell] is YES; [NOTE: Column B data has no bearing or impact on Condition THREE] Hope this explains it a little more clearly and I definitely hope you can help me out! ================================================== == "T. Valko" wrote: Ooops! Typos! C1 = fill with color if A1 = a date <=today and C1 = no =AND(COUNT(A1),A1<=TODAY(),C1="no") All references to C1 should be B1. -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Try this... A1 = some date B1 = yes or no C1 = fill with color if A1 = a date <=today and C1 = no Select cell C1 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the little box to the right: =AND(COUNT(A1),A1<=TODAY(),C1="no") Click the Format button Select the Patterns tab Select the color of your choice OK out -- Biff Microsoft Excel MVP "dinocm" wrote in message ... I want to use two different cells in a single row (one a date-formatted cell & one a "Yes/No" text value cell) to display a cell fill color in a third cell - based on the conditions (e.g., date is <= today and text is "no" - filling third cell with red) present; How can I do this? Txs! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill a cell color using date in one cell and "yes/no" in anoth
Ok, try these:
Condition 1 Formula Is: =AND(COUNT(B1),B1<TODAY(),C1="no") Set color to RED Condition 2 Formula Is: =AND(COUNT(B1),B1=TODAY(),C1="no") Set color to GOLD/YELLOW Condition 3 Formula Is: =C1="yes" Set color to GREEN -- Biff Microsoft Excel MVP "dinocm" wrote in message ... "T. VALKO" - Below is the result I am trying to achieve: IF B$ IS <TODAY AND C$=NO, THEN FILL A$ AS RED; IF B$ IS =TODAY AND C$=NO, THEN FILL A$ AS GOLD; IF C$=YES, THEN FILL A$ AS GREEN; Condition ONE: Column A [cell] is filled RED when Column B [cell] entered date is before the current date AND Column C [cell] is NO; Condition TWO: Column A [cell] is filled GOLD when Column B [cell entered date is either the current or a future date AND Column C [cell] is NO; Condition THREE: Column A [cell] is filled GREEN when Column C [cell] is YES; [NOTE: Column B data has no bearing or impact on Condition THREE] Hope this explains it a little more clearly and I definitely hope you can help me out! ================================================== == "T. Valko" wrote: Ooops! Typos! C1 = fill with color if A1 = a date <=today and C1 = no =AND(COUNT(A1),A1<=TODAY(),C1="no") All references to C1 should be B1. -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Try this... A1 = some date B1 = yes or no C1 = fill with color if A1 = a date <=today and C1 = no Select cell C1 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the little box to the right: =AND(COUNT(A1),A1<=TODAY(),C1="no") Click the Format button Select the Patterns tab Select the color of your choice OK out -- Biff Microsoft Excel MVP "dinocm" wrote in message ... I want to use two different cells in a single row (one a date-formatted cell & one a "Yes/No" text value cell) to display a cell fill color in a third cell - based on the conditions (e.g., date is <= today and text is "no" - filling third cell with red) present; How can I do this? Txs! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill a cell color using date in one cell and "yes/no" in anoth
While waiting for a response, I tried this in the 3rd condition line:
=OR(B8=TODAY(),B8<TODAY(),E8="YES") Both my solution AND yours worked - but your was MUCH SIMPLER!! Thank you for your assistance! "dinocm" "T. Valko" wrote: Ok, try these: Condition 1 Formula Is: =AND(COUNT(B1),B1<TODAY(),C1="no") Set color to RED Condition 2 Formula Is: =AND(COUNT(B1),B1=TODAY(),C1="no") Set color to GOLD/YELLOW Condition 3 Formula Is: =C1="yes" Set color to GREEN -- Biff Microsoft Excel MVP "dinocm" wrote in message ... "T. VALKO" - Below is the result I am trying to achieve: IF B$ IS <TODAY AND C$=NO, THEN FILL A$ AS RED; IF B$ IS =TODAY AND C$=NO, THEN FILL A$ AS GOLD; IF C$=YES, THEN FILL A$ AS GREEN; Condition ONE: Column A [cell] is filled RED when Column B [cell] entered date is before the current date AND Column C [cell] is NO; Condition TWO: Column A [cell] is filled GOLD when Column B [cell entered date is either the current or a future date AND Column C [cell] is NO; Condition THREE: Column A [cell] is filled GREEN when Column C [cell] is YES; [NOTE: Column B data has no bearing or impact on Condition THREE] Hope this explains it a little more clearly and I definitely hope you can help me out! ================================================== == "T. Valko" wrote: Ooops! Typos! C1 = fill with color if A1 = a date <=today and C1 = no =AND(COUNT(A1),A1<=TODAY(),C1="no") All references to C1 should be B1. -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Try this... A1 = some date B1 = yes or no C1 = fill with color if A1 = a date <=today and C1 = no Select cell C1 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the little box to the right: =AND(COUNT(A1),A1<=TODAY(),C1="no") Click the Format button Select the Patterns tab Select the color of your choice OK out -- Biff Microsoft Excel MVP "dinocm" wrote in message ... I want to use two different cells in a single row (one a date-formatted cell & one a "Yes/No" text value cell) to display a cell fill color in a third cell - based on the conditions (e.g., date is <= today and text is "no" - filling third cell with red) present; How can I do this? Txs! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
fill a cell color using date in one cell and "yes/no" in anoth
You're welcome!
-- Biff Microsoft Excel MVP "dinocm" wrote in message ... While waiting for a response, I tried this in the 3rd condition line: =OR(B8=TODAY(),B8<TODAY(),E8="YES") Both my solution AND yours worked - but your was MUCH SIMPLER!! Thank you for your assistance! "dinocm" "T. Valko" wrote: Ok, try these: Condition 1 Formula Is: =AND(COUNT(B1),B1<TODAY(),C1="no") Set color to RED Condition 2 Formula Is: =AND(COUNT(B1),B1=TODAY(),C1="no") Set color to GOLD/YELLOW Condition 3 Formula Is: =C1="yes" Set color to GREEN -- Biff Microsoft Excel MVP "dinocm" wrote in message ... "T. VALKO" - Below is the result I am trying to achieve: IF B$ IS <TODAY AND C$=NO, THEN FILL A$ AS RED; IF B$ IS =TODAY AND C$=NO, THEN FILL A$ AS GOLD; IF C$=YES, THEN FILL A$ AS GREEN; Condition ONE: Column A [cell] is filled RED when Column B [cell] entered date is before the current date AND Column C [cell] is NO; Condition TWO: Column A [cell] is filled GOLD when Column B [cell entered date is either the current or a future date AND Column C [cell] is NO; Condition THREE: Column A [cell] is filled GREEN when Column C [cell] is YES; [NOTE: Column B data has no bearing or impact on Condition THREE] Hope this explains it a little more clearly and I definitely hope you can help me out! ================================================== == "T. Valko" wrote: Ooops! Typos! C1 = fill with color if A1 = a date <=today and C1 = no =AND(COUNT(A1),A1<=TODAY(),C1="no") All references to C1 should be B1. -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... Try this... A1 = some date B1 = yes or no C1 = fill with color if A1 = a date <=today and C1 = no Select cell C1 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the little box to the right: =AND(COUNT(A1),A1<=TODAY(),C1="no") Click the Format button Select the Patterns tab Select the color of your choice OK out -- Biff Microsoft Excel MVP "dinocm" wrote in message ... I want to use two different cells in a single row (one a date-formatted cell & one a "Yes/No" text value cell) to display a cell fill color in a third cell - based on the conditions (e.g., date is <= today and text is "no" - filling third cell with red) present; How can I do this? Txs! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Incorporating Cell color fill in an "if" logical function? | Excel Worksheet Functions | |||
How do I change the fill color of a cell using an "IF" function | Excel Worksheet Functions | |||
How to change text color in a cell "comment" in Office 2007? | Excel Worksheet Functions | |||
Excel needs multiple "Fill color" buttons for faster coloring. | Setting up and Configuration of Excel | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) |