ExcelBanter - Formatting

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formatting (https://www.excelbanter.com/excel-discussion-misc-queries/212067-formatting.html)

Terry Boat

Formatting

I need help with the below:

If the value in cell a1 has a corresponding value in Tabel c1:h15, then can
I change the color of cell a1 to blue?

-
Terry

Gary''s Student

Formatting

click on a1 and:
Format Conditional Formatting Formula Is =COUNTIF(C1:H15,A1)0 and
pick the color
--
Gary''s Student - gsnu200817

"Terry Boat" wrote:

I need help with the below:

If the value in cell a1 has a corresponding value in Tabel c1:h15, then can
I change the color of cell a1 to blue?

-
Terry

All times are GMT +1. The time now is 10:22 AM.