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

Report
Posts
1
Registration date
Monday October 3, 2016
Status
Member
Last seen
October 3, 2016
-
Posts
2718
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
April 15, 2021
-
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.

1 reply

Posts
2718
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
April 15, 2021
459
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!