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.