CF ROWS
 

Hi all-
Can you please tell me HOW to accomplish the following:

I have a Y/N field in column Q (rows are NOT finite; adding rows daily to
the s/s) which indicates an approval for 1st submit to customer. IF the
submit is approved, this would have a "Y" entered and then I would like the
ENTIRE ROW to be greyed out.

However, there is another cell (T) which has the same parameters. So, if
submit one fails, we can move onto submit 2 and then the "Y" would get
entered into this cell (vs. Q) and then the ENTIRE ROW should get greyed out.

So, sometimes the trigger is in column Q and sometimes (more often than I
care to admit!), the trigger would be in column T. Is there someway to
conditionaly format for each scenario or both?

And, how can I make sure the range is dynamic becuase, as I mentioned, more
date (rows) are added to this report daily/weekly, etc.

Thanks IN ADVANCE for the help/direction.

CF ROWS
 

Select a row of data - say row 2. Go to FormatConditional Formatting.
Select 'Formula is' and use this formula

=or($Q2="Y",$T2="Y")

Then click on the Format button and set your formatting


"marcy" wrote:

Hi all-
Can you please tell me HOW to accomplish the following:

I have a Y/N field in column Q (rows are NOT finite; adding rows daily to
the s/s) which indicates an approval for 1st submit to customer. IF the
submit is approved, this would have a "Y" entered and then I would like the
ENTIRE ROW to be greyed out.

However, there is another cell (T) which has the same parameters. So, if
submit one fails, we can move onto submit 2 and then the "Y" would get
entered into this cell (vs. Q) and then the ENTIRE ROW should get greyed out.

So, sometimes the trigger is in column Q and sometimes (more often than I
care to admit!), the trigger would be in column T. Is there someway to
conditionaly format for each scenario or both?

And, how can I make sure the range is dynamic becuase, as I mentioned, more
date (rows) are added to this report daily/weekly, etc.

Thanks IN ADVANCE for the help/direction.

CF ROWS
 

Thanks, Duke. But, one more point, please: How can I make sure that the
range is ongoing and that the CF will follow the size of the report?

My data rows being as you say with row 2 and right now I am up to 144 but
next week, I will likely be at 200+.

Hate to press my luck but this detail wil be quite useful, please.

"Duke Carey" wrote:

Select a row of data - say row 2. Go to FormatConditional Formatting.
Select 'Formula is' and use this formula

=or($Q2="Y",$T2="Y")

Then click on the Format button and set your formatting


"marcy" wrote:

Hi all-
Can you please tell me HOW to accomplish the following:

I have a Y/N field in column Q (rows are NOT finite; adding rows daily to
the s/s) which indicates an approval for 1st submit to customer. IF the
submit is approved, this would have a "Y" entered and then I would like the
ENTIRE ROW to be greyed out.

However, there is another cell (T) which has the same parameters. So, if
submit one fails, we can move onto submit 2 and then the "Y" would get
entered into this cell (vs. Q) and then the ENTIRE ROW should get greyed out.

So, sometimes the trigger is in column Q and sometimes (more often than I
care to admit!), the trigger would be in column T. Is there someway to
conditionaly format for each scenario or both?

And, how can I make sure the range is dynamic becuase, as I mentioned, more
date (rows) are added to this report daily/weekly, etc.

Thanks IN ADVANCE for the help/direction.

CF ROWS
 

Sorry for the incomplete answer. After you've got the CF done for a dingle
row, copy it for several hundred rows, down to the point that you'd
reasonably expect to have data, plus a small cushion

By copy it I mean:
Select the row where you've done the CF and EditCopy
Now select the same columns but as many rows as you want and EditPaste
SpecialFormat




"marcy" wrote:

Thanks, Duke. But, one more point, please: How can I make sure that the
range is ongoing and that the CF will follow the size of the report?

My data rows being as you say with row 2 and right now I am up to 144 but
next week, I will likely be at 200+.

Hate to press my luck but this detail wil be quite useful, please.

"Duke Carey" wrote:

Select a row of data - say row 2. Go to FormatConditional Formatting.
Select 'Formula is' and use this formula

=or($Q2="Y",$T2="Y")

Then click on the Format button and set your formatting


"marcy" wrote:

Hi all-
Can you please tell me HOW to accomplish the following:

I have a Y/N field in column Q (rows are NOT finite; adding rows daily to
the s/s) which indicates an approval for 1st submit to customer. IF the
submit is approved, this would have a "Y" entered and then I would like the
ENTIRE ROW to be greyed out.

However, there is another cell (T) which has the same parameters. So, if
submit one fails, we can move onto submit 2 and then the "Y" would get
entered into this cell (vs. Q) and then the ENTIRE ROW should get greyed out.

So, sometimes the trigger is in column Q and sometimes (more often than I
care to admit!), the trigger would be in column T. Is there someway to
conditionaly format for each scenario or both?

And, how can I make sure the range is dynamic becuase, as I mentioned, more
date (rows) are added to this report daily/weekly, etc.

Thanks IN ADVANCE for the help/direction.

CF ROWS
 

Thanks so much for this follow-up!

"Duke Carey" wrote:

Sorry for the incomplete answer. After you've got the CF done for a dingle
row, copy it for several hundred rows, down to the point that you'd
reasonably expect to have data, plus a small cushion

By copy it I mean:
Select the row where you've done the CF and EditCopy
Now select the same columns but as many rows as you want and EditPaste
SpecialFormat




"marcy" wrote:

Thanks, Duke. But, one more point, please: How can I make sure that the
range is ongoing and that the CF will follow the size of the report?

My data rows being as you say with row 2 and right now I am up to 144 but
next week, I will likely be at 200+.

Hate to press my luck but this detail wil be quite useful, please.

"Duke Carey" wrote:

Select a row of data - say row 2. Go to FormatConditional Formatting.
Select 'Formula is' and use this formula

=or($Q2="Y",$T2="Y")

Then click on the Format button and set your formatting


"marcy" wrote:

Hi all-
Can you please tell me HOW to accomplish the following:

I have a Y/N field in column Q (rows are NOT finite; adding rows daily to
the s/s) which indicates an approval for 1st submit to customer. IF the
submit is approved, this would have a "Y" entered and then I would like the
ENTIRE ROW to be greyed out.

However, there is another cell (T) which has the same parameters. So, if
submit one fails, we can move onto submit 2 and then the "Y" would get
entered into this cell (vs. Q) and then the ENTIRE ROW should get greyed out.

So, sometimes the trigger is in column Q and sometimes (more often than I
care to admit!), the trigger would be in column T. Is there someway to
conditionaly format for each scenario or both?

And, how can I make sure the range is dynamic becuase, as I mentioned, more
date (rows) are added to this report daily/weekly, etc.

Thanks IN ADVANCE for the help/direction.

CF ROWS
 

One more question, if I may:

I created a NAMED RANGE for this s/s: "samples" with the dynamic range as
follows:

=OFFSET($A$1,0,0,COUNTA($A:$A),1)

Can I use the formula you gave me for the CF and incorporate this named
range so I can be sure it covers entires as far as I go?

Y'see what a little knowlege can do....thanks again!


"Duke Carey" wrote:

Sorry for the incomplete answer. After you've got the CF done for a dingle
row, copy it for several hundred rows, down to the point that you'd
reasonably expect to have data, plus a small cushion

By copy it I mean:
Select the row where you've done the CF and EditCopy
Now select the same columns but as many rows as you want and EditPaste
SpecialFormat




"marcy" wrote:

Thanks, Duke. But, one more point, please: How can I make sure that the
range is ongoing and that the CF will follow the size of the report?

My data rows being as you say with row 2 and right now I am up to 144 but
next week, I will likely be at 200+.

Hate to press my luck but this detail wil be quite useful, please.

"Duke Carey" wrote:

Select a row of data - say row 2. Go to FormatConditional Formatting.
Select 'Formula is' and use this formula

=or($Q2="Y",$T2="Y")

Then click on the Format button and set your formatting


"marcy" wrote:

Hi all-
Can you please tell me HOW to accomplish the following:

I have a Y/N field in column Q (rows are NOT finite; adding rows daily to
the s/s) which indicates an approval for 1st submit to customer. IF the
submit is approved, this would have a "Y" entered and then I would like the
ENTIRE ROW to be greyed out.

However, there is another cell (T) which has the same parameters. So, if
submit one fails, we can move onto submit 2 and then the "Y" would get
entered into this cell (vs. Q) and then the ENTIRE ROW should get greyed out.

So, sometimes the trigger is in column Q and sometimes (more often than I
care to admit!), the trigger would be in column T. Is there someway to
conditionaly format for each scenario or both?

And, how can I make sure the range is dynamic becuase, as I mentioned, more
date (rows) are added to this report daily/weekly, etc.

Thanks IN ADVANCE for the help/direction.

CF ROWS
 

I think you are not looking at it the right way up.

The CF applies to the single cell. Whatever the size of your range, the CF
applies independently to each. The best thing is to select many more cells
than you need and apply CF to them all. As you add data, it will trigger the
CF.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"marcy" wrote in message
...
One more question, if I may:

I created a NAMED RANGE for this s/s: "samples" with the dynamic range as
follows:

=OFFSET($A$1,0,0,COUNTA($A:$A),1)

Can I use the formula you gave me for the CF and incorporate this named
range so I can be sure it covers entires as far as I go?

Y'see what a little knowlege can do....thanks again!


"Duke Carey" wrote:

Sorry for the incomplete answer. After you've got the CF done for a
dingle
row, copy it for several hundred rows, down to the point that you'd
reasonably expect to have data, plus a small cushion

By copy it I mean:
Select the row where you've done the CF and EditCopy
Now select the same columns but as many rows as you want and EditPaste
SpecialFormat




"marcy" wrote:

Thanks, Duke. But, one more point, please: How can I make sure that
the
range is ongoing and that the CF will follow the size of the report?

My data rows being as you say with row 2 and right now I am up to 144
but
next week, I will likely be at 200+.

Hate to press my luck but this detail wil be quite useful, please.

"Duke Carey" wrote:

Select a row of data - say row 2. Go to FormatConditional
Formatting.
Select 'Formula is' and use this formula

=or($Q2="Y",$T2="Y")

Then click on the Format button and set your formatting


"marcy" wrote:

Hi all-
Can you please tell me HOW to accomplish the following:

I have a Y/N field in column Q (rows are NOT finite; adding rows
daily to
the s/s) which indicates an approval for 1st submit to customer.
IF the
submit is approved, this would have a "Y" entered and then I would
like the
ENTIRE ROW to be greyed out.

However, there is another cell (T) which has the same parameters.
So, if
submit one fails, we can move onto submit 2 and then the "Y" would
get
entered into this cell (vs. Q) and then the ENTIRE ROW should get
greyed out.

So, sometimes the trigger is in column Q and sometimes (more often
than I
care to admit!), the trigger would be in column T. Is there
someway to
conditionaly format for each scenario or both?

And, how can I make sure the range is dynamic becuase, as I
mentioned, more
date (rows) are added to this report daily/weekly, etc.

Thanks IN ADVANCE for the help/direction.

CF ROWS
 

got it and thanks so much to both gentlemen!!

"Bob Phillips" wrote:

I think you are not looking at it the right way up.

The CF applies to the single cell. Whatever the size of your range, the CF
applies independently to each. The best thing is to select many more cells
than you need and apply CF to them all. As you add data, it will trigger the
CF.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"marcy" wrote in message
...
One more question, if I may:

I created a NAMED RANGE for this s/s: "samples" with the dynamic range as
follows:

=OFFSET($A$1,0,0,COUNTA($A:$A),1)

Can I use the formula you gave me for the CF and incorporate this named
range so I can be sure it covers entires as far as I go?

Y'see what a little knowlege can do....thanks again!


"Duke Carey" wrote:

Sorry for the incomplete answer. After you've got the CF done for a
dingle
row, copy it for several hundred rows, down to the point that you'd
reasonably expect to have data, plus a small cushion

By copy it I mean:
Select the row where you've done the CF and EditCopy
Now select the same columns but as many rows as you want and EditPaste
SpecialFormat




"marcy" wrote:

Thanks, Duke. But, one more point, please: How can I make sure that
the
range is ongoing and that the CF will follow the size of the report?

My data rows being as you say with row 2 and right now I am up to 144
but
next week, I will likely be at 200+.

Hate to press my luck but this detail wil be quite useful, please.

"Duke Carey" wrote:

Select a row of data - say row 2. Go to FormatConditional
Formatting.
Select 'Formula is' and use this formula

=or($Q2="Y",$T2="Y")

Then click on the Format button and set your formatting


"marcy" wrote:

Hi all-
Can you please tell me HOW to accomplish the following:

I have a Y/N field in column Q (rows are NOT finite; adding rows
daily to
the s/s) which indicates an approval for 1st submit to customer.
IF the
submit is approved, this would have a "Y" entered and then I would
like the
ENTIRE ROW to be greyed out.

However, there is another cell (T) which has the same parameters.
So, if
submit one fails, we can move onto submit 2 and then the "Y" would
get
entered into this cell (vs. Q) and then the ENTIRE ROW should get
greyed out.

So, sometimes the trigger is in column Q and sometimes (more often
than I
care to admit!), the trigger would be in column T. Is there
someway to
conditionaly format for each scenario or both?

And, how can I make sure the range is dynamic becuase, as I
mentioned, more
date (rows) are added to this report daily/weekly, etc.

Thanks IN ADVANCE for the help/direction.