Conditional Formatting Help

[davygryan]

I have a spreadsheet that is used to track Actions from Meetings.

What I need to do is that if an action is complete, I want to make that complete row Green, if the action is Overdue make that row red and all other actions will have no format.

What will i have to do to do this.

 

[Andrew Poulsom]

If the action is in A1, select the entire row and use a conditional formatting formula like:

=$A1="complete"

The $ sign fixes the column reference.

 

[davygryan]

If the action is in A1, select the entire row and use a conditional formatting formula like:

=$A1="complete"

The $ sign fixes the column reference.

I have the text "Complete" in cell G4, and I want row 4 to be green and so on down through the sheet.

Does this make any sense. I really appreciate your help

 

[Andrew Poulsom]

Select all the rows you want to format. With row 4 active use the formula:

=$G4="Complete"

 

[davygryan]

Select all the rows you want to format. With row 4 active use the formula:

=$G4="Complete"

Thank you Andrew.

One final Question If I wanted to make a single cell green based on the value in a nother cell how would I do that

 

[Andrew Poulsom]

If you want to format B1 when A1 contains Complete, in B1 use:

=A1="Complete"

 

[davygryan]

If you want to format B1 when A1 contains Complete, in B1 use:

=A1="Complete"

Cool I have it now.

I feel so stupid. Thanks so much for your help