Conditional format make a row a color based on another cell

Closed

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 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - 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.

Excel conditional formatting based on another cell color
Excel clear formatting - Guide
Excel conditional formatting based on date - Guide
Based on the cell values in cells b77 ✓ - Excel Forum
How to change date format in excel - Guide
Excel mod apk for pc - Download - Spreadsheets

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 555
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

Similar discussions

Conditional Format Cells Based on Another Cell and Own Cell

Clear cell contents based on value of another cell range using VBA

How to use conditional format based on text?

Conditional formatting based text in another cell

Highlight cell if another cell contains specific text

Similar discussions

Subscribe To Our Newsletter!