Conditional Formatting Help

I have a spreadsheet where if cell K1 is not blank, then it colors cell A1 and so on....
So, if K2 is blank, it won't color A2, if K3 is not blank, it colors A3, etc.

Thank you

Microsoft ExcelSpreadsheets

Last Comment

Farah Mohammed

8/22/2022 - Mon

ASKER CERTIFIED SOLUTION

Tj a

4/27/2015

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Farah Mohammed

4/27/2015

ASKER

How do I apply that conditional formatting to the other rows? row 2 will refer to K2, row 3 to K3 and so on?

Thank you

Tj a

4/27/2015

I edited my first comment to show how but you might not have noticed that change.

To apply that conditional formula to the cells below it, click the cell with the formula and click "Format Painter" in the Clipboard group then select the range of cells that you want to format. It automatically formats them.

Farah Mohammed

4/27/2015

ASKER

Thank you!!

Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!

Certified Expert Program

Credly Partnership

Udemy Partnership