Previous Topic Next Topic

Conditional format make a row a color based on another cell

Closed
Ellestee Posts 1 Registration date Monday 3 October 2016 Status Member Last seen 3 October 2016 - 3 Oct 2016 à 20:08
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 4 Oct 2016 à 11:11
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.
Related:

1 response

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
4 Oct 2016 à 11:11
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
Elaine -
x -

1 response
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response