YTLE#78: Conditional Format for Entire Table

I have a workbook with 40 columns being used.

if lets say a row in column AL = "NO"
I want that entire row formatted with lets say BOLD RED Text.

Is this possible? and how is it achieved?

Is there a way to have the entire row turn a color once ALL cells are filled?

I have a form that needs to have data in each cell of the table. Once each item in that particular row contains data, that item is complete. I would like to have the row turn a color once it is complete.

The cells of the first row of data would be A2-N2 and each row after that would be follow A3-N3, etc. I got it to do one cell at a time, but I want each cell in the entire range of A2-N2 to have to have data before the row gets colored, and if data gets deleted from a cell, the row would go back to white.

Any help would be appreciated.
Thanks!

Currently I created a relatively simple spreadsheet which a few rows will be added each day. These rows span A3 through I3 - Whenever there is a date (and for simplicty, anything) in H column (H3, H4, etc.) I want to format the entire row with a green background. Is this something that should be done with conditional formatting, or with macros? Please let me know how would be the best way to do this, I've never done conditional formatting on multiple cells.

What is the proper syntax to highlight an entire row with conditional formatting if a cell contains the word total?

I found this post was able to re-jig it it for what I need for an entire column.

http://www.mrexcel.com/board2/viewto...l+format+sheet

What I came up with in the conditional format is this...

=INDEX(cola1,ROW())INDEX(colf,ROW())

where cola1 is ColumnA in Sheet one (and where the conditional format occurs) and cola is Column A from sheet 2.

Here's the question...how do I do the exact same thing for rows? I thought it was something like...

=INDEX(COL(),myrow1)INDEX(COL(), myrow) but that doesn;t seem to work. Where am I going wrong?

I can't figure out to place conditional formatting on a range at each change in cells in column A....ie. in column A, several rows will have the value "1", then several will have the value "2", all the way through "52"...sometimes there could be 4 rows with the same value, otheres there may be 5, or others even only 1.....so I need conditional formatting that says each time the value in column A changes, highlight all cells in that row one color and change that color at each change. Does that make sense?

I have a large spreadsheet which consists of about 10 columns. It is basically a listing of information found in a human resources database, so information varies. However, in the last column of each row there is either a "0" or a "1." How do I create a conditional format to highlight the entire row if the value in the last cell of that row is "1." and apply it to every row. I just want rows highlighted if I find the number"1" in last column.

Hello,

I've been Googling for a few hours with no luck on finding the answer to my question, so I decided to post here to find some help.

I have a document in Excel 2003, and I'd like to highlight the overdue dates in one column and the rest of the row for the date. I've been using the formula "=ISBLANK(A1)=TRUE" along with "cell value is less than '=NOW()'", which I found doing a Google search. This works fine in highlighting the overdue dates in my document, but I can't figure out how to also highlight the rest of the row. I'm not sure I'm explaining myself well, so I've attached an example.

FormatExample.xls

I'd appreciate any help that you can give me. I've been at this for hours.

Hi basically what im trying to do is highlight say all row 25 is g25= left

I have not worked with conditional formatting much at all. I have been able to apply conditional formatting to a column of data, but I would like to highlight the entire row instead of just the one cell in that column.

Say I have five columns of data for each record (ID Number, Address, City, State, ZIP Code). I know how to apply conditional formatting based on the zip code and have Excel highlight the cells in the zip code column that meet my conditions. What I would like to do is have it highlight not just the zip code, but also the ID number, address, city, and state when a zip code meets a condition.

Thanks, Spence