CF ROWS

[Guest]

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.

 

[Guest]

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

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

Then click on the Format button and set your formatting

 

[Guest]

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.

 

[Guest]

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 Edit>Copy
Now select the same columns but as many rows as you want and Edit>Paste
Special>Format

 

[Guest]

Thanks so much for this follow-up!

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 Edit>Copy
Now select the same columns but as many rows as you want and Edit>Paste
Special>Format

 

[Guest]

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!

 

[Bob Phillips]

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)

 

[Guest]

got it and thanks so much to both gentlemen!!

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)