Change cell colour if criteria is met

[Rutz]

Good Day,

How can I automatically change the cell colour of a couple of rows (eg A20:G20), as soon as there is a value in eg I20?

Thank you in advance

Rudz

[NeedForExcel]

You can use conditional formatting..

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[AliGW]

Use a conditional formatting rule on A20:G20 using a formula that establishes whether the cell is blank or not:

=ISBLANK(I20)=FALSE

[Khalidngo]

Hi,
Select your range: A20:G20

Go to Conditional Formatting,
Formula:
=$I$20<>""

Set format as required.

Blessing

[Rutz]

I have attached a sample workbook

Thanks

Rudz

[Rutz]

Thank you very much people!! My problem is now solved!!

[Khalidngo]

I have attached a sample workbook

Thanks

Rudz

Select your range, go to conditional formatting:

Use this in CF formula:

=$T3="OK"

Regards,