CF Row after CF applied to Column

D

Dax Arroway

I've been reading the posts but still don't get it. I have data down columns
A:O for 2000+ rows. In Column J, I selected the entire column and applied CF
to it so that if any text is entered into a cell, that cell will turn yellow.
I'm lost as to how to get the entire row A:O of each cell in J which
contains text to turn yellow. I'm running 07. Can anyone help me in English
as to what the steps are or point me to the appropriate post?

Thanks in advance!
-Dax
 
J

Jacob Skaria

--Select the range of cells. Assume this range is A1:O2000. Please note that
the row number mentioned in the formula is the row containing the active cell
in the selection. Active cell will have a white background even after
selection

--Goto Home tab>Styles>Conditional Formatting>Manage rules>New rule>Use a
formula to determine which cells to format

--Enter this formula in the box below:
=ISTEXT($J1)

--Click the Format button. Select the desired style(s). Hit OK

If this post helps click Yes
 
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.
 
D

Dax Arroway

Thanks for the help. It actually gets worse. In column C I'm entering M or
F (for male or female) and I need to color the entire row either blue or pink
(yeah, I know, I know, sorry to stereotype but it's not my worksheet)
depending upon their sex. How do I specify the text in that specific column?
I tried =ISTEXT($C1,"M") but it says those are too many arguements. Not
sure where to go from there.
Any help?
 
G

Gord Dibben

Select range A1:O2000

Condition1 CF formula would be =$C1="M"

Condition2 CF formula would be =$C1="F"


Gord Dibben MS Excel MVP
 

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