Conditional Formatting 1 cell if another has any type of data there

[weaselmcguff]

Conditional formatting issue.

I want column M to be highlighted if there text in column P.

I have tried in Column M conditional formatting =ISBLANK<>"" and nothing changes with a fill of RED
I have tried in Column M conditional formatting =$P$13<>"" Fill of RED and ALL cells change to RED even those that are empty

What am i missing?

Thanks for your time

 

[duggie33]

Hi weaselmcguff,

For your conditional formatting in column M, select the range you want to conditionally format, create a new rule, then "Use a formula to...", and add the format changes (highlight, font, etc.). In the formula bar, add one or more of the following:

• When the cell in column P of the same row is not blank, try; =NOT(ISBLANK(P1))
  • If you want to base the formatting on a specific cell in column P, make it an absolute reference, like $P$1
• When the cell in column P of the same row has text in it, try; =CELL("type",P1)="l"
• When the cell in column P of the same row has a number in it, try; =CELL("type",P1)="v"

I would not conditionally format the whole column, only what you need or are using. Adding extra cells only makes your file size larger and it will calculate slower.

I hope that helps,

Doug

 

[Fluff]

How about

Fluff.xlsm
	M	N	O	P
1
2	1			a
3	1
4	1			b
5	1
6	1
7	1			c
8	1
9	1
10	1			c
11	1
12
13
14
15
Main

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
M2:M15	Expression	=P2<>""	text	NO