Conditional Formatting Help First Row First Column Data

[MeepMeep]

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!

 

[MeepMeep]

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

 

[Gerald Higgins]

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]

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
	A	B	C	D	E
1					bleed
2
3	try				23
4	grab
5	red
6	trial
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]

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]

Here

Excel 2010
	A	B	C	D	E	F	G	H	I
1	SATURDAY	SUNDAY	MONDAY	TUESDAY	WEDNESDAY	THURSDAY	FRIDAY	SATURDAY	SUNDAY
2	DATA		DATA	DATA	DATA	DATA	DATA	DATA
3		DATA	DATA	DATA	DATA	DATA	DATA		DATA
4	DATA		DATA	DATA	DATA	DATA	DATA	DATA
5		DATA	DATA	DATA	DATA	DATA	DATA	DATA
6		DATA	DATA	DATA	DATA	DATA	DATA	DATA
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

 

[MeepMeep]

THANK YOU VERY MUCH!! This was exactly what I needed!

Here

Excel 2010

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

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</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