Conditional format entire row?

[Pyrex238]

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.

[jeffreybrown]

How about...

=$H3<>""

Highlight the range A3:I3 and enter this formula in conditional formatting

[Marcol]

Go with conditional formatting

See here
Contextures - Excel Conditional Formatting -- Introduction

See also the links at the bottom of the link page

Related Tutorials
Excel Conditional Formatting -- Introduction
Excel Conditional Formatting -- Based on another cell
Excel Conditional Formatting -- Examples
Excel Conditional Formatting -- Documentation
Excel Conditional Formatting -- Data Bars

[Pyrex238]

How about...

=$H3<>""

Highlight the range A3:I3 and enter this formula in conditional formatting

Yes that works on a per row basis, but how am I suppose to apply this to the entire spreadsheet? Wouldn't I have to have 500 different conditional formatting rules?

edit: I'm stupid, I got it figured out - thank you very much for your help.

[Pyrex238]

One last question... What is the proper formula to format a cell if $A<>"" and $G<"0" ? How should I write that? Couldn't get it to work with if(and

[jeffreybrown]

How about...

=AND($A3<>"",$G3<0)

[Marcol]

You need to return TRUE/FALSE

Try, for example

Please Login or Register  to view this content.

[Pyrex238]

Awesome, works great.

[jeffreybrown]

Glad it worked for you