Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Use conditional formatting with equation is:
=AND((LEN(A1)=8),(LEFT(A1,6)="PD10/ ")) This will be true if the first 6 characters match your pattern and the total length is 8 characters (which covers your ** condition) -- Gary's Student "Nikki" wrote: I want to format a row to change background color if a cell in the row says PD10/ 05. But it won't always say 05- how can I make a generic for that in an equation. I tried "pd10/ **" but it didn't like that. Is there a way to do this? -- Thanks, Nikki |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom Formatting For Multiple Currency Symbols | Excel Discussion (Misc queries) | |||
make custom formatting permanent | Excel Worksheet Functions | |||
Custom Formatting for Dates | Excel Discussion (Misc queries) | |||
Custom charts - default formatting | Charts and Charting in Excel | |||
Custom formatting to force a decimal place | Excel Discussion (Misc queries) |