Conditional formatting question
In conditional formatting, select Formula is, not Cell value is.
Insert the following: =Left(<Cell Addr,1)="D", eg =LEFT(A1,1),"D". Select
Format, Patterns and Red.
Should you then put a D in A1, or Dummy, or Date, or D 8/17, the cell will
turn red.
--
Hth
Kassie Kasselman
Change xxx to hotmail
" wrote:
I want a cell to be highlighted red if it contains the letter D AT
ALL. Not just highlighted if the cell ONLY has a D.
For Example: a cell that = "D 8/17" or "D 9/10" should be highlighted
red. The dates after the D will constantly be different, I just want
any cells with the capital letter D in them to be filled in w/red.
Any ideas on how to do this? Conditional formatting only allows me to
fill the cell with red if it equals JUST D. Not D + random date. Any
help is much appreciated, thanks!
|