ExcelBanter - Conditional Formatting

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Conditional Formatting (https://www.excelbanter.com/new-users-excel/447236-conditional-formatting.html)

Jenniferpod

Conditional Formatting

I want to fill any cell in column f yellow that matches any cell from column w.

Spencer101

1 Attachment(s)

Quote:

Originally Posted by Jenniferpod (Post 1605884)

I want to fill any cell in column f yellow that matches any cell from column w.

How's this?

Have a look at the formula used for the conditional formatting.

Jenniferpod

Quote:

Originally Posted by Spencer101 (Post 1605907)

How's this?

Have a look at the formula used for the conditional formatting.

Works perfect!! Thank you!

All times are GMT +1. The time now is 09:40 AM.