CF to Row after CF is applied to Column

D

Dax Arroway

Can someone please help me? I've read through the postings and the help
files but still can't seem to figure out how to do this. I've applied
conditional formatting to the J column of my spreadsheet so that if there's
any text listed the cell turns yellow. What I'd like is if not only the cell
but the row, from A:O turned yellow also. How do you do that? I'm using 07.
Any help in English walking me through the steps or a hint toward the
appropriate post would be greatly appreciated. Cuz I aint figrin it out on
myown!

Thanks in advance!
--Dax
 
P

Pete_UK

Highlight the cells in columns A to O that you want this to apply to
(assume this is from A2 to O100, with A2 as the active cell). Then
bring up the Conditional Formatting dialogue box. In the first panel
you need to select Formula Is rather than Cell Value Is, and then put
this formula in the next box:

=$J2<>""

Then click on the Format button, select the Patterns tab and choose
yellow. Then click on OK twice to exit the dialogue box.

Excel will automatically adjust the formulae to suit the range that
you had highlighted, so now the cells from A to O in any row should
appear yellow if the cell in column J of that row is not empty.

If you want it specifically for text values (rather than numbers),
then you could use:

=ISTEXT($J2)

as your formula, or even:

=AND($J2<>"",NOT(ISNUMBER($J2)))

Hope this helps.

Pete
 
D

Dax Arroway

Thanks for your help and sorry about the multi-posting, I waited 5 minutes
and didn't see my posting and thought I had done something wrong.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top