Conditional format make a row a color based on another cell [Closed]

Question

Conditional format make a row a color based on another cell [Closed]

Report

Ellestee

Posts: 1
Registration date: Monday October 3, 2016
Status: Member
Last seen: October 3, 2016

- Oct 3, 2016 at 08:08 PM
TrowaD

Posts: 2718
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: April 15, 2021

- Oct 4, 2016 at 11:11 AM

Hi,

I have a large spreadsheet with many rows and columns. I want to color a row green when we have been paid on that line.

There is a column to enter the date of payment, which varies. I want the row to turn green when any value is added to that one column - can I make this formula effective for every row? How?

Thank you.

Conditional format make a row a color based on another cell
Conditional formating for entire rows ✓ - Forum - Excel
Copy conditional formatting from one row to another ✓ - Forum - Excel
Excel vba change cell color based on another cell value ✓ - Forum - Programming
How to copy a row in excel based on a cell value ✓ - Forum - Excel
Copy rows to other sheets based on value in column ✓ - Forum - Excel

1 reply

Ask a question

TrowaD · Answer 1 · 2016-10-04T11:11:58-0400

Answer 1 / 1

TrowaD

Posts: 2718
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: April 15, 2021

459
Oct 4, 2016 at 11:11 AM

Hi Ellestee,

The following scenario will color the entire row when a value is entered in column C:
Choose to use a formula in conditional formatting.
Formula: =$C1<>"" Change the C to the column letter you use.
Applied range: =$1:$99 Change 99 to the amount of rows you have.

Best regards,
Trowa

Conditional format make a row a color based on another cell [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!