# Conditional Formatting Help First Row First Column Data

#### MeepMeep

##### New Member
Hi All,

I can't seem to find this information anywhere on how to complete this.

I want to create a conditional format formula that will look for data in the first row and first column and highlight cells with that range that are blank with a specified column name.

Example the formula will find that there is data in A3 as the first column and E1 as the first row and that First row data is Saturday, I would like if E3 was blank to be highlighted/filled with a color.

I am trying to do this with the column values of Saturday and Sunday. Any help would be extremely appreciated!

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

#### MeepMeep

##### New Member
Or highlight a blank cell in a column with the first row with the data value of Saturday or Sunday

#### Gerald Higgins

##### Well-known Member
Hi, welcome to the board.

This is probably do-able but I'm not completely clear what you actually want.

Can you please post a small sample of your data, making it clear exactly what should be highlighted by the CF, and why.

#### Momentman

##### Well-known Member
I have tp agree with Gerald, what you seek isn't exactly clear but I gave a shot at what i thought you wanted

Its not the best of formulas,

1. Select your data range, i have assumed her A1 to P100, change as necessary

Excel 2010
ABCDE
1bleed
2
3try23
4grab
5red
6trial
7
Sheet4

The conditional formatting formula highlights/colors cell E3 so long as its not blank

=AND(ROW(A1)=MATCH("*",\$A\$1:\$A\$100,0),COLUMN(A1)=MATCH("*",\$A\$1:\$P\$1,0),INDEX(\$A\$1:\$Q\$100,MATCH("*",\$A\$1:\$A\$100,0),MATCH("*",\$A\$1:\$P\$1,0))<>0)=TRUE

#### MeepMeep

##### New Member
Hi All,

Thank you for your replies, here is a sample data

 A B C D E F G H I 1 SATURDAY SUNDAY MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY SATURDAY SUNDAY 2 DATA (COLOR) DATA DATA DATA DATA DATA DATA (COLOR) 3 (COLOR) DATA DATA DATA DATA DATA DATA (COLOR) DATA 4 DATA (COLOR) DATA DATA DATA DATA DATA DATA (COLOR) 5 (COLOR) DATA DATA DATA DATA DATA DATA DATA (COLOR) 6 (COLOR) DATA DATA DATA DATA DATA DATA DATA (COLOR)

<tbody>
</tbody>

This worksheet will continually update and get longer and longer by adding additional weeks. I am trying to get anything in the columns containing Saturday or Sunday with blank cells to be highlighted.

I marked the blank cells that i wanted colored with (COLOR), I didn't know how to change the color on the tables on here.

#### Momentman

##### Well-known Member
Here

Excel 2010
ABCDEFGHI
1SATURDAYSUNDAYMONDAYTUESDAYWEDNESDAYTHURSDAYFRIDAYSATURDAYSUNDAY
Sheet6

1. Highlight the required range
2. Go to conditional formatting and select to use a formula to format
3 And formula would be
=AND(OR(A\$1="SATURDAY",A\$1="SUNDAY"),A2="")=TRUE

Last edited:

#### MeepMeep

##### New Member
THANK YOU VERY MUCH!! This was exactly what I needed!

Here

Excel 2010
ABCDEFGHI
1SATURDAYSUNDAYMONDAYTUESDAYWEDNESDAYTHURSDAYFRIDAYSATURDAYSUNDAY

</tbody>
Sheet6

1. Highlight the required range
2. Go to conditional formatting and select to use a formula to format
3 And formula would be
=AND(OR(A\$1="SATURDAY",A\$1="SUNDAY"),A2="")=TRUE

Replies
8
Views
279
Replies
13
Views
547
Replies
5
Views
468
Replies
7
Views
2K
Replies
1
Views
507

1,191,043
Messages
5,984,298
Members
439,882
Latest member
gerdc

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back