weaselmcguff
Board Regular
- Joined
- Feb 24, 2006
- Messages
- 246
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
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