 |
 |
|
|
|
07-19-2008, 12:53 PM
|
|||
|
|||
|
Conditional Formatting
Hi guys,
I have set up a couple of conditional formatting rules to colour cells if they meet the requirements i have set. However, could someone let me know what format condition i need to enter in order to keep the cell white if no text is entered into the cell? Cheers, Rodney 
|
|
07-19-2008, 01:38 PM
|
|||
|
|||
|
Re: Conditional Formatting
You don't need a condition, if it doesn't meet the others it stays
uncoloured. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Rodney" <Rodney@discussions.microsoft.com> wrote in message news:0D762BDF-98D7-492F-AF3E-7A1180E84445@microsoft.com... > Hi guys, > > I have set up a couple of conditional formatting rules to colour cells if > they meet the requirements i have set. However, could someone let me know > what format condition i need to enter in order to keep the cell white if > no > text is entered into the cell? > > Cheers, > Rodney
|
|
07-19-2008, 02:28 PM
|
|||
|
|||
|
Re: Conditional Formatting
Hi Bob,
I dont think what i wrote made sense. Basically the cells i have turn red if they exceed a date or stay green if they are below. However, that means the cells are red until anything a date is entered into the cell. Can i set another condition to make them stay white if nothing is in the cell? Cheers. "Bob Phillips" wrote: > You don't need a condition, if it doesn't meet the others it stays > uncoloured. > > -- > HTH > > Bob > > (there's no email, no snail mail, but somewhere should be gmail in my addy) > > "Rodney" <Rodney@discussions.microsoft.com> wrote in message > news:0D762BDF-98D7-492F-AF3E-7A1180E84445@microsoft.com... > > Hi guys, > > > > I have set up a couple of conditional formatting rules to colour cells if > > they meet the requirements i have set. However, could someone let me know > > what format condition i need to enter in order to keep the cell white if > > no > > text is entered into the cell? > > > > Cheers, > > Rodney > > >
|
|
07-19-2008, 05:51 PM
|
|||
|
|||
|
Re: Conditional Formatting
I don't see how an empty cell would turn red, empty is not greater than any
date. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Rodney" <Rodney@discussions.microsoft.com> wrote in message news:8068093D-8A70-439D-9B3E-F03F8C6E912A@microsoft.com... > Hi Bob, > > I dont think what i wrote made sense. Basically the cells i have turn red > if > they exceed a date or stay green if they are below. However, that means > the > cells are red until anything a date is entered into the cell. Can i set > another condition to make them stay white if nothing is in the cell? > > Cheers. > > "Bob Phillips" wrote: > >> You don't need a condition, if it doesn't meet the others it stays >> uncoloured. >> >> -- >> HTH >> >> Bob >> >> (there's no email, no snail mail, but somewhere should be gmail in my >> addy) >> >> "Rodney" <Rodney@discussions.microsoft.com> wrote in message >> news:0D762BDF-98D7-492F-AF3E-7A1180E84445@microsoft.com... >> > Hi guys, >> > >> > I have set up a couple of conditional formatting rules to colour cells >> > if >> > they meet the requirements i have set. However, could someone let me >> > know >> > what format condition i need to enter in order to keep the cell white >> > if >> > no >> > text is entered into the cell? >> > >> > Cheers, >> > Rodney >> >> >>
|
|
07-19-2008, 06:07 PM
|
|||
|
|||
|
Re: Conditional Formatting
Hi Bob,
The formatting is as follows: If the cell value is less than todays date it turns red. If the cell value is equal to or more than todays date it turns green. I think that as empty is less than todays date thats why it turns red? Cheers, Rod "Bob Phillips" wrote: > I don't see how an empty cell would turn red, empty is not greater than any > date. > > -- > HTH > > Bob > > (there's no email, no snail mail, but somewhere should be gmail in my addy) > > "Rodney" <Rodney@discussions.microsoft.com> wrote in message > news:8068093D-8A70-439D-9B3E-F03F8C6E912A@microsoft.com... > > Hi Bob, > > > > I dont think what i wrote made sense. Basically the cells i have turn red > > if > > they exceed a date or stay green if they are below. However, that means > > the > > cells are red until anything a date is entered into the cell. Can i set > > another condition to make them stay white if nothing is in the cell? > > > > Cheers. > > > > "Bob Phillips" wrote: > > > >> You don't need a condition, if it doesn't meet the others it stays > >> uncoloured. > >> > >> -- > >> HTH > >> > >> Bob > >> > >> (there's no email, no snail mail, but somewhere should be gmail in my > >> addy) > >> > >> "Rodney" <Rodney@discussions.microsoft.com> wrote in message > >> news:0D762BDF-98D7-492F-AF3E-7A1180E84445@microsoft.com... > >> > Hi guys, > >> > > >> > I have set up a couple of conditional formatting rules to colour cells > >> > if > >> > they meet the requirements i have set. However, could someone let me > >> > know > >> > what format condition i need to enter in order to keep the cell white > >> > if > >> > no > >> > text is entered into the cell? > >> > > >> > Cheers, > >> > Rodney > >> > >> > >> > > >
|
|
07-19-2008, 06:25 PM
|
|||
|
|||
|
Re: Conditional Formatting
See your other post.
-- Biff Microsoft Excel MVP "Rodney" <Rodney@discussions.microsoft.com> wrote in message news:29D69E89-E9EA-4D2F-AFEC-918F34DDE2EF@microsoft.com... > Hi Bob, > > The formatting is as follows: > > If the cell value is less than todays date it turns red. > If the cell value is equal to or more than todays date it turns green. > > I think that as empty is less than todays date thats why it turns red? > > Cheers, > Rod > > "Bob Phillips" wrote: > >> I don't see how an empty cell would turn red, empty is not greater than >> any >> date. >> >> -- >> HTH >> >> Bob >> >> (there's no email, no snail mail, but somewhere should be gmail in my >> addy) >> >> "Rodney" <Rodney@discussions.microsoft.com> wrote in message >> news:8068093D-8A70-439D-9B3E-F03F8C6E912A@microsoft.com... >> > Hi Bob, >> > >> > I dont think what i wrote made sense. Basically the cells i have turn >> > red >> > if >> > they exceed a date or stay green if they are below. However, that means >> > the >> > cells are red until anything a date is entered into the cell. Can i set >> > another condition to make them stay white if nothing is in the cell? >> > >> > Cheers. >> > >> > "Bob Phillips" wrote: >> > >> >> You don't need a condition, if it doesn't meet the others it stays >> >> uncoloured. >> >> >> >> -- >> >> HTH >> >> >> >> Bob >> >> >> >> (there's no email, no snail mail, but somewhere should be gmail in my >> >> addy) >> >> >> >> "Rodney" <Rodney@discussions.microsoft.com> wrote in message >> >> news:0D762BDF-98D7-492F-AF3E-7A1180E84445@microsoft.com... >> >> > Hi guys, >> >> > >> >> > I have set up a couple of conditional formatting rules to colour >> >> > cells >> >> > if >> >> > they meet the requirements i have set. However, could someone let me >> >> > know >> >> > what format condition i need to enter in order to keep the cell >> >> > white >> >> > if >> >> > no >> >> > text is entered into the cell? >> >> > >> >> > Cheers, >> >> > Rodney >> >> >> >> >> >> >> >> >>
|
|
07-19-2008, 06:55 PM
|
|||
|
|||
|
Re: Conditional Formatting
So test for
=AND(C1<>"",C1<TODAY()) -- __________________________________ HTH Bob "Rodney" <Rodney@discussions.microsoft.com> wrote in message news:29D69E89-E9EA-4D2F-AFEC-918F34DDE2EF@microsoft.com... > Hi Bob, > > The formatting is as follows: > > If the cell value is less than todays date it turns red. > If the cell value is equal to or more than todays date it turns green. > > I think that as empty is less than todays date thats why it turns red? > > Cheers, > Rod > > "Bob Phillips" wrote: > >> I don't see how an empty cell would turn red, empty is not greater than >> any >> date. >> >> -- >> HTH >> >> Bob >> >> (there's no email, no snail mail, but somewhere should be gmail in my >> addy) >> >> "Rodney" <Rodney@discussions.microsoft.com> wrote in message >> news:8068093D-8A70-439D-9B3E-F03F8C6E912A@microsoft.com... >> > Hi Bob, >> > >> > I dont think what i wrote made sense. Basically the cells i have turn >> > red >> > if >> > they exceed a date or stay green if they are below. However, that means >> > the >> > cells are red until anything a date is entered into the cell. Can i set >> > another condition to make them stay white if nothing is in the cell? >> > >> > Cheers. >> > >> > "Bob Phillips" wrote: >> > >> >> You don't need a condition, if it doesn't meet the others it stays >> >> uncoloured. >> >> >> >> -- >> >> HTH >> >> >> >> Bob >> >> >> >> (there's no email, no snail mail, but somewhere should be gmail in my >> >> addy) >> >> >> >> "Rodney" <Rodney@discussions.microsoft.com> wrote in message >> >> news:0D762BDF-98D7-492F-AF3E-7A1180E84445@microsoft.com... >> >> > Hi guys, >> >> > >> >> > I have set up a couple of conditional formatting rules to colour >> >> > cells >> >> > if >> >> > they meet the requirements i have set. However, could someone let me >> >> > know >> >> > what format condition i need to enter in order to keep the cell >> >> > white >> >> > if >> >> > no >> >> > text is entered into the cell? >> >> > >> >> > Cheers, >> >> > Rodney >> >> >> >> >> >> >> >> >>
|
 |
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
