conditional format of entire row based on a single cell in row

C

CEG_Staffer

I have a worksheet with data in cols A - L. I would like to conditionally
format each row based on wheter (or not) text is in the cell of col D. If
text is in cell of col D, the color of row = green. If no text in cell of col
D, no color.
 
R

Rajesh Mehmi

Select Row A to L

conditional formatting

formula is =$D2<>""

then select the formatting .. green etc


Regards

Rajesh Mehmi
(e-mail address removed)
 
C

CEG_Staffer

Thanks. I input this in the formula is and only the first 2 cells of the row
were highlighted. Any suggestions?
 
R

Rajesh Mehmi

Select A2 to L2 or the whole row
then start the conditional formatting

--
Best regards

Rajesh Mehmi

(e-mail address removed)
 
C

CEG_Staffer

Thanks all. Now, how can I "copy" this conditional formatting to each row of
the worksheet without manually creating the same format function?
 
C

CEG_Staffer

Never mind the last request, I failed to use the "$". Is there any way to
apply this conditional format function to each row of the worksheet (approx
50 rows of data)?
 
R

Rajesh Mehmi

Select All conditionally formatted cells in row and pull down as you copy a
normal formula.
--
Best regards

Rajesh Mehmi

(e-mail address removed)
 

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

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Conditional Formatting on several sheets of the same file 2
Conditional Format based on value of another cell 5
Conditional format stoplight based on worst color 3
Placing Col & Row identifiers into a cell as text 3
[XL07] Conditionally format fill color for entire row 10
function returning SUM of 2 adjacent cols in 2 separate cells 7
Conditional format a column based on value in a different column 3

Top